ll.orasql.scripts · Python software

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