RE: Oracle 8i database & ER diagram

THANK YOU TOM!!! This message alone is FAR better information than ALL of the GARBAGE put together that Oracle has available on their sites (TechNet, Metalink, all of 'em) on how to use Designer. At least now I have some idea of where to begin. Thanks so much!

-::YEX::-
<)))><

-----Original Message-----
Sent: Tuesday, 12 June, 2001 11:01 AM
To: Multiple recipients of list ORACLE-L

Yex,

Start Up designer.
Click on Repsitory Object Navigator
Select Application Systems
Click the Green Plus Icon (left menu bar) and create an application system (name it something you like to identify it as your application).

Noe, go back to the Oracle Designer startup panel and Click on the Design Editor Icon.
Under Global Shared Workarea, open up your application. Create an Oracle database by (again) clicking on the Green Icon. Create the user you wish to reverse-engineer from. The user within the Repository database will become the placeholder for all of the database objects.

Click on the user you just created.

select (from the menu on the top) Generate|Capture Design of|Server Model This will give you a dialogue window with more options. Enter the Oracle Account/Password and connect string for the database you are rev-engineering from. *** Look at the TARGET CONTAINER/CAPTURE IMPLEMENTATIONS INTO selection at the bottom - make sure these are correct. Select the Objects tab and reverse engineer the database objects one at a time ion the following order:

Tablespaces
  if these do not exist before you rev-eng the tables, you get warnings Database Roles (only capture the roles you created for your application)   you need these to correctly reverse-engineer grants to objects. Database Users (skip the one user you created by hand)   again - to capture the grants to database objects Now you can begin your schema objects
Sequences
Tables
Views   

If you have a large amount of database objects, you may want to break up the capture of the tables into sections. Be prepared for application crashes - it gets overwhelmed at times. Also, have a lot of patience. Thsi can be done, but you may have to perservere to succeed!

good luck!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, June 12, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L

Would you mind explaining to me how to go about reverse-engineering a database with Designer please. I downloaded Designer6i a couple of weeks ago, and have been trying ever since to figure out how to reverse-engineer our database into an ER diagram, but the docs for Designer are absolutely WORTHLESS, and it doesn't explain anywhere (not that I can find anyway) HOW to go about doing a reverse-engineering of an existing database.

Any help would be GREATLY appreciated. Thanks.

-::YEX::-
<)))><

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yexley Robert D SSgt AFIT/SCA
  INET: Robert.Yexley_at_afit.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).