Skip to content

Oracle ddl generator - puts a python command line on the dbms.metadata package.

Notifications You must be signed in to change notification settings

tyrdare/ddlgenerator-oracle

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ddlgenerator-oracle

Oracle ddl generator - puts a python command line on the dbms_metadata.get_ddl function.

"python ddl_generator.py -h"

will tell you something useful.

Can get DDL for

  • tables
  • indexes
  • sequences
  • functions
  • procedures
  • packages
  • types
  • triggers
  • database links
  • synonyms
  • views

Works on

  • 9i
  • 10g
  • 11g
  • maybe 12c (not tested)

Dependencies:

cx_Oracle Oracle client libraries installation

TODO:

  • Add an "all" modifier on object options
  • Add a "get everything at once" option.
  • Allow concurrent processes for large schemas. dbms_metadata.get_ddl is not the fastest thing in the world...

About

Oracle ddl generator - puts a python command line on the dbms.metadata package.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages