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.
(Resolved) Reverse Engg. Schema Objects in Oracle Desginer Repository Owner
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 ..