Procedure | Description |
dry_run |
Whether to execute changes or only log statements which would be executed.
Parameters: BOOLEAN enable |
initiate_semantics_table |
(Re-)fill the table holding information about all character type fields (to be converted to CHAR semantic)
No parameters. |
initiate_nchars_table |
Check for all tables having NCHAR columns (to be converted to CHAR)
No parameters. |
initiate_nvarchars_table |
Check for all tables having NVARCHAR columns (to be converted to VARCHAR2)
No parameters. |
initiate_nclobs_table |
Check for all tables having NCLOB columns (to be converted to CLOB)
No parameters. |
initiate_constraints_table |
Save all current constraint states (to re-establish later)
No parameters. |
semantics2char |
Change length semantics to CHAR for all character fields in the database.
No parameters. |
convert_nchar |
Convert NCHAR columns to CHAR for the schemata to migrate.
No parameters. |
convert_nvarchar |
Convert NVARCHAR fields to VARCHAR2 for the schemata to migrate.
No parameters. |
convert_nclob |
Convert NCLOB fields to CLOB for the schemata to migrate.
No parameters. |
truncate_long_fields |
Truncate character fields larger than 4000 byte for the schemata to migrate.
No parameters. |
disable_triggers |
Disable all database triggers for the affected schemata
No parameters. |
disable_constraints |
Disable all database constraints for the affected schemata
No parameters. |
copy_tables |
Copy all table data for the affected schemata
No parameters. |
copy_sequences |
Re-Create all sequences for the affected schemata (last values may have changed since the strucure export!)
No parameters. |
enable_constraints |
Re-Enable all constraints which we disabled before
No parameters. |
enable_triggers |
Same for the triggers |
validate_constraints |
Render all enabled constraints VALIDATED for the affected schemata
No parameters. |
schema_stats |
Gather schema stats for the imported data
Parameters: NUMBER percent for estimate stats (default: 30),
NUMBER degree for parallelism (default: 4; should not
exceed the count of CPUs in the machine) |
compile_invalid |
Compile all objects for the migrated schemata
This procedure compiles all procedures, functions, packages and triggers
for the schemata listed in the iz_owners table. Since some
of them may have been invalidated during the migration, it is recommended
to run this procedure - even if the objects may get compiled when called.
No parameters. |