oraddlscript

oraddlscript is a command-line utilty based on the concept of SMOscript to generate CREATE scripts of database objects in an Oracle database.

oraddlscript uses the functions DBMS_METADATA.GET_DDL and GET_XML to retrieve CREATE statements and XML representation of all objects owned by a specified user.

oraddlscript 0.14.3584.16268 (c) by devio.at 2009

list and script databases and database objects.

usage: oraddlscript [options] [command]

options: (leading '-' or '/')

-s server TNS name or host name or host:port
-svc service service name (if host name is provided)
-o owner owner name

-u username username (default: integrated authentication)
-p password password (if -u is missing, password for sa)

-f filename output to file
-F directory output to directory

-A current ANSI codepage
-O ASCII
-T Unicode
-U UTF8

commands:

l list objects
s script object/s (using dbms_meta.get*ddl)
-xml use dbms_meta.get*xml

list object owners on server (implied by -s)
list objects in database (implied by -s -o)
script all objects (implied by -s -o -F/-f)

The oraddlscript utility implements the following functions:

  • list all object owners in a database
  • list all objects owned by a database user
  • script CREATE for each object in database
  • create XML representation for each object in database

Resulting script are either written to a single file, or to a separate file for each object.

Command line switches were selected to be compatible with scptxfr, but support both “-” and “/” as switch marker.

devioblog describes the latest changes to oraddlscript here. oraddlscript is available for download here.