Reference of Functions and Procedures
Main Procedures
ProcedureDescription
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.
Other procedures
Besides the procedures needed by the migration, there are two more public procedures contained in the package, which may be useful for you:
ProcedureDescription
print A wrapper to dbms_output.put_line. Since that procedure is limited to 255 characters, and we don't want (or even cannot) count what we are going to output, this wrapper runs around it. If the string to output is too long, it will wrap the output at the closest blank to the 255 character limit and output the chunks.
Parameters: VARCHAR2 output_string
log Write a message to the log file. If the message is too long (exceeding the 4000 bytes that can be stored in the VARCHAR2 field), it is truncated. The logging then will be done in the iz_logging table of the executing user.
Parameters: CHAR(1) loglevel, VARCHAR2 message