|Purpose||This package contains utilities to upgrade the type dictionary images from 8.0 to 8.1. The dictionary tables that could be in 8.0 are kottd$, kottb$, kottbx$, kotad$ and kotmd$, which existed in 8.0 or 8.1, when 8.0 compatibility was possible, kotadx$ was created in 9iR2 when we required 8.1 minimum compatibility.|
|First Available||Not known but ~2007|
|Security Model||Owned by SYS with no privileges granted|
|DELETE_ORPHAN_TYPEIDCOLS (new 12.1)|
|Clean up all orphaned entries in col$.
Read source code notes
|FIX_KOTTD_IMAGES (new 12.1)|
|RECOMPILE_TYPES (new 12.1)|
|Used during upgrade/downgrade and was the only way to recompile a type with table dependents||dbms_objects_utils.recompile_types(names IN dbms_objects_utils_tnamearr);|
|This function splits the source$ entry for the latest version of the type to its CREATE and ALTERs and returns the number or of split sources||dbms_objects_utils.split_source(
tschema IN CHAR,
tname IN CHAR,
sources OUT dbms_objects_utils_tsource)
|Will take in 2 schema names, schema1 and schema2 and for each type type1 present in schema2 and schema1, it will make any object column/table dependent on schema1.type1 point to schema2.type1||-- can also be used for updating just one type in schema1. In that case give the typename as the 3rd parameter.
If you give NULL for typename it will default to the above behaviour.
schema1 IN VARCHAR2,
schema2 IN VARCHAR2,
typename IN VARCHAR2,
check_update IN BOOLEAN);
|Upgrades the type dictionary images from 8.0 to 8.1. The||dbms_objects_utils.upgrade_dict_image;|
|This site is maintained by Dan Morgan. Last Updated:||This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2013 Daniel A. Morgan All Rights Reserved|