Dec 30, 2011

Oracle Get DDL script

Keywords:  Oracle, DDL, stdout
Depends on:  sqlplus (and its dependencies)
Download:  get_ddl

On many occasions I need to fetch DDL/source for Oracle objects (e.g. tables, views, packages, etc.) from the Database.

The get_ddl shell script is a wrapper around Oracle's DBMS_METADATA package.  It's an on-demand script:  as the demand requires, I add another object.

Updates
  • 1.1 - -i option to pull a specific index DDL.

No comments:

Post a Comment