Cont From Part 1

At the top of the Design Editor window go to Generate->Capture Design
of->Server Model

Source of Design Capture - > Database
enter username, I use "sys"
password, sys's password
Connect: database name (I'm using tnsnames, so I enter the name of the
database I want knowing that I've already put it in tnsnames.ora.)
Owner: the is the schema owner that owns the tables that I want to reverse
engineer.

Target Container: lazydba example (name I used in RON)

Capture Implementations Into: lazy (name I gave my dummy database on the DB
Admin tab)

Database User: USER1 - which was created when I created the database
earlier

Additional Containters: leave blank

I check every one of the 5 boxes at the bottom of the window and for
Post Design Capture: I choose "browse/edit mode" instead of commit

Now you're ready to hit the Objects tab at the top of the window.

Available Objects for Capture:
I click on "Relational Tables" on the "Don't Capture" side of the window so
that it is highlighted and then click on the single > in the center of the
window so that the tables appear on the right "Capture" side of the window
and then click on start at the bottom of the screen.

A "Message Window" appears I might get some warnings, but that's ok. If you
get errors, you need to fix the errors before you can continue.

If you get "0 error(s)", then close that message window.

Cont on Part 3


Daniel Miller [Email Address Removed] Database Administrator
Raytheon Corporation
USGS EROS Data Center
Mundt Federal Building
Sioux Falls, SD 57198
PHONE: 605-594-6182
FAX: 605-594-6940


Oracle LazyDBA home page