| Script Name |
Description |
c_clone_grants.sql |
This script will "clone" SYS, OBJECT and ROLE level privs for any schema
by creating a SQL script that can be used to copy these privs to another
schema within the same database or a different database.
|
c_proc_extract.sql |
This script will extract source code for the following source types:
1. PACKAGE
2. PACKAGE BODY
3. FUNCTION
4. PROCEDURE
The source code will be spooled into a file named after the source name
|
c_rebuild_synonyms.sql |
Reverse engineers synonyms (DB LINKS are supported)
|
c_tab_rec.sql |
Creates DDL script to re-create a table
|
c_tab_rec_plsql.sql |
Reverse Engineer Table DDL
|
c_tab_rec_plsql_all.sql |
Reverse Engineer Table DDL including
constraints. Allows tablespace change for
INDEXES generated by constraints and the
TABLE it self. Doesn`t handle partitions.
|
c_tabsp_tmp_rebuild.sql |
This script rebuilds any LOCAL TEMPORARY tablespace
|
s_dbf_migrate.sql |
When migrating to a different host sometimes
it is necessary to balance datafiles on new
file systems to make sure you do not go over
the available space.
--
For instance if your original host had 20GB
file systems and your new host is only 12GB
you can find this script very handy.
--
This script should be ran on the sourse instance
before the migration. It will display a line "---"
when SUM of all datafiles reached the limit you
specified
|