Dump Oracle Metadata To SQL File

DumpObjectSQL

*) Description :
Create Data Definition Language from your Oracle Database Object,
using Oracle DBMS_METADATA and cx_Oracle.

*) Dependency:
cx_Oracle
Oracle 10g2 Client

*) Usage:
1. Create output directory
sample:
mkdir -p /app/dump_out/TABLE
mkdir -p /app/dump_out/VIEW
mkdir -p /app/dump_out/PACKAGE
mkdir -p /app/dump_out/PROCEDURE
mkdir -p /app/dump_out/TRIGGER
mkdir -p /app/dump_out/SEQUENCE
mkdir -p /app/dump_out/TYPE

2. call DumpObjectSQL.py
run command :
python DumpObjectSQL.py [user] [password] [sid] [object type] [output directory]

user = database user
password = database password
sid = database service id
object type = [TABLE, VIEW, PACKAGE, PROCEDURE, TRIGGER, SEQUENCE, TYPE]
output directory = output directory you created

git://github.com/sroctadian/DumpObjectSQL.git