scripts – Oracle related scripts

This package contains the following scripts:

oracreate
oracreate prints (or executes in another schema) the SQL of all objects in an Oracle database schema (i.e. all tables, procedures, functions, views, etc.)
oradrop
oradrop prints (or executes) drop statements for all objects in an Oracle database schema.
oradelete
oradelete prints (or executes) SQL for deleting all records from all tables in an Oracle database schema.
oragrant
oragrant prints (or executes) grants statements from an Oracle database schema.
orafind
orafind can be used to search for a string in all fields of all tables in an Oracle database schema.
oradiff
oradiff can be used for finding the differences between two Oracle database schemas.
oramerge
oramerge can be used for merging the changes between two Oracle database schemas into a third one.

These scripts can either be called via Pythons -m option:

python -mll.orasql.scripts.oracreate --help

or as a simple script installed in the search path:

oracreate --help