RE: Reverse Engineering for Oracle Designer
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'jacintakean@xxxxxxxxx'" <jacintakean@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 14 Jan 2005 09:04:55 -0500
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@xxxxxxxxx]
Sent: Friday, January 14, 2005 4:20 AM
To: oracle-l@xxxxxxxxxxxxx
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
---------------------------------
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
