Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Reverse Engineering for Oracle Designer
Kean,
Start the RON.
Right click on "Global Shared WorkArea" - select "Create Child/Application
System.
Within the Application, create an Oracle Database.
Create the User.
Start the Design Editor.
Click on the "DB Admin" Tab.
Select "Generate|Capture Design of|Server Model" from the menu.
Enter the Source of Design Capture as your database and enter the connect
information.
Select the Target Container and Capture Implementations Into via the
drop-down.
Reverse Engineer the items separately in the following order:
Roles
Users (You can create these users by hand if you want to).
Tablespaces
Tables
Views
PL/SQL stuff (triggers, Procs & Packages).
Triggers will come automatically of you selected the option on the capture window. A new diagram will be automatically created for you - but it is slower. I usually create my diagrams by hand.
This is not a trivial task. Capturing the tables can take a long time. But once you do it, keeping it up to date is not a big deal.
Good Luck!
Tom
-----Original Message-----
From: Kean Jacinta [mailto:jacintakean_at_yahoo.com]
Sent: Friday, January 14, 2005 4:20 AM
To: oracle-l_at_freelists.org
Subject: Reverse Engineering for Oracle Designer
I have problem using oracle designer. I have succesfully intalled the product in my machine. How can i generate an erd diagram, gather all trigger,view iinformation from my existing database.
Example : i have devCRM schema. This schema contains all the table, view, procedure and etc.. How can i generate and ER Diagram ?
Your help is very much appreciated
Thank you
Cheers
JKean
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 14 2005 - 08:00:05 CST