oracle-scripts

Collection of personal useful Oracle scripts.

Naming conventions

• rep_* : Report, use without parameters.
• com_* : Command, usage require parameters. Check script to know more.
• gen_* : Generator, use to output prepared SQL commands automatically. Combine with spool to generate SQL scripts quickly.

Oracle Norms

• Indexes

• Tablespaces

• Indexes and constraints

• Structure

• Database organization

• Schema organization

Responsability note

These scripts are part of the tools that I use in my job. As such, these are of course offered without any warranty of any kind. Read each script before use.