Reverse Engg. Schema Objects in Oracle Desginer Repository Owner
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Reverse Engg. Schema Objects in Oracle Desginer Repository Owner

  1. #1
    Join Date
    Feb 2004
    Location
    Mumbai, Maharastra
    Posts
    67

    Reverse Engg. Schema Objects in Oracle Desginer Repository Owner

    Need some guidance as to how i can import or reverse engg. from a existing schema to the repository user (oracle designer repository user) so that i can get the ER diagram created.
    Regards,
    Surajit K Mitra

  2. #2
    Join Date
    Feb 2004
    Location
    Mumbai, Maharastra
    Posts
    67
    can anyone put some light on the matter i posted.
    Regards,
    Surajit K Mitra

  3. #3
    Join Date
    Feb 2005
    Posts
    158
    There is a function in Designer for this (check the HELP), but whether it is workable depends on what version of Designer and version and features used in the server.
    We gave up when we found that our version of Designer couldn't cope with index organized tables, bitmap indexes, partitions, materialized views and practically anything else invented after Oracle 6.

  4. #4
    Join Date
    Feb 2004
    Location
    Mumbai, Maharastra
    Posts
    67

    (Resolved) Reverse Engg. Schema Objects in Oracle Desginer Repository Owner

    Problem resolved.
    Open Oracle9i Designer -> Click Design Editor

    Select the workarea created, goto Server Model Diagram
    In the menu option select Generate -> Capture Design Of -> Server Model

    Enter the parameters and start the process (this will capture all objects from the target schema and store the same in the repository user).

    Save the diagram

    Go back to Oracle9i Designer -> Select Entity Relationship Designer -> Create a New ERD (select the desired container)

    Goto Utilities -> Table to Entry Retrofit -> Click Candidate Tables -> Select All the objects -> Click on Retrofit -> Click Close

    Right click on the ER diagram page -> Include -> Entity -> Select All -> Ok

    got it .. u r presented with the ER diagram ..
    Regards,
    Surajit K Mitra

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width