Wednesday, May 20, 2020

How to export data dictionary with Oracle SQL Developer

Oracle SQL Developer is a free development tool for Oracle database. It has a nice feature of generating data dictionary and exporting it to HTML.

To generate data dictionary create connection to your database, then select connection, right click and choose Generate DB Doc....
Then choose output directory and optionally take time to select database object types.
Click OK and wait for export to complete. This is how it looks:


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...

  • Oracle Integration Cloud Service(OICS) links
    Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
  • 12c SOA - how to create csf-key
    Credential Store Framework (CSF) is used in OWSM to manage the secure credentials. CSF provides a way to store, retrieve, and delete cred...
  • 12c OSB Throttling
    What is Throttling: Throttling is termed as "regulate the flow". Oracle Service Bus has throttling feature and by using that f...