The following steps will describe how to generate Database/ER diagram from an existing Oracle DB using Oracle Data Modeler,
1. In Oracle Data Modeler, select File -> Import -> Data Dictionary
2. In data dictionary import wizard step 1 connect Database, select Add button and provide existing Database connection details and click connect,
3. Select the added Database and click next, In step 2 Select schema/Database select the schema to import and click Next.
4. In step 3 Select objects to import, select the objects to import and click Next.
5. In step 4 Generate design, click finish. The ER diagram will be generated.
1. In Oracle Data Modeler, select File -> Import -> Data Dictionary
2. In data dictionary import wizard step 1 connect Database, select Add button and provide existing Database connection details and click connect,
3. Select the added Database and click next, In step 2 Select schema/Database select the schema to import and click Next.
4. In step 3 Select objects to import, select the objects to import and click Next.
5. In step 4 Generate design, click finish. The ER diagram will be generated.
Thanks this info was really helpful! I used a website called Lucidchart to create my own er diagram and it was really easy to understand. If you use diagrams often you should check it out!
ReplyDeleteVery informative! I have also found some great ER Diagram Examples using Lucidchart and their site is very helpful and easy to use! Give it a try!
ReplyDeleteYou can find more er templates with explanation in creately diagram community. There are 1000s of examples and templates to be used freely.
ReplyDelete