How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

by

Create a diagram for existing database schema or its subset as follows:

  1. Click File → Data Modeler → Import → Data Dictionary.
  2. Select a DB connection (add one if none).
  3. Click Next.
  4. Check one or more schema names.
  5. Click Next.
  6. Check one or more objects to import.
  7. Click Next.
  8. Click Finish.

The ERD is displayed.

Export the diagram as follows:

  1. Click File → Data Modeler → Print Diagram → To Image File.
  2. Browse to and select the export file location.
  3. Click Save.

The diagram is exported. To export in a vector format, use To PDF File, instead. This allows for simplified editing using Inkscape (or other vector image editor).

These instructions may work for SQL Developer 3.2.09.23 to 4.1.3.20.

More Related Contents:

  1. How can I set a custom date time format in Oracle SQL Developer?
  2. Printing the value of a variable in SQL Developer
  3. How to export query result to csv in Oracle SQL Developer?
  4. How to avoid variable substitution in Oracle SQL Developer
  5. NLS_NUMERIC_CHARACTERS setting for decimal
  6. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  7. Spool Command: Do not output SQL statement to file
  8. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  9. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  10. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  11. How to put more than 1000 values into an Oracle IN clause [duplicate]
  12. ORA-30926: unable to get a stable set of rows in the source tables
  13. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  14. Fetch Oracle table type from stored procedure using JDBC
  15. “Safe” TO_NUMBER()
  16. When or Why to use a “SET DEFINE OFF” in Oracle Database
  17. error: ORA-65096: invalid common user or role name in oracle
  18. Oracle insert if not exists statement
  19. Error : ORA-01704: string literal too long
  20. Reason why oracle is case sensitive?
  21. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  22. Oracle date difference to get number of years
  23. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  24. Oracle: how to add minutes to a timestamp?
  25. How to drop multiple interval partitions based on date?
  26. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  27. merge update oracle unable to get a stable set of rows
  28. How to change default nls_date_format for oracle jdbc client
  29. How to generate a GUID in Oracle?
  30. Escaping single quote in PLSQL

Leave a Comment