Reverse Engineering using Erwin Modeler

Reverse Engineering Oracle User using Erwin Modeler

Using 

Create a new Model - [ File -> New ] / Ctrl + N

select the target database ( here oracle 10g is chosen ) and click on Next

Choose Database option to import object details by connecting to database.  In the options listed right choose Current User to import details of user, which we are going to use when establishing the database connection.

     Make sure Primary Keys, Relations options are checked to draw foreign key relation of schema objects.


Click on Next to continue to key in database details.

Choose Authentication type as Database Authentication and key in the User Name, Password and Connection String Parameter value.


Click on Connect to begin the Reverse Engineering Process and finally you will get the Schema details as shown below

Now you can do modification to this logical structure depending on the new business requirement.