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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
