| General Information |
| Note: The source code is fully exposed for both package header and body. |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsobj.sql |
| First Available |
11.1.0.6 |
| Dependencies |
| DBMS_OBJECT_UTILS_TINFO |
DBMS_OBJECT_UTILS_TSOURCE |
| DBMS_OBJECT_UTILS_TSELEM |
DBMS_OUTPUT |
|
| Security Model |
Owned by SYS and no privileges are granted |
| Subprograms |
| SPLIT_SOURCE |
UPDATE_TYPES |
UPGRADE_DICT_IMAGE |
|
| |
SPLIT_SOURCE (new 11.2.0.3)  |
| Splits the source$ entry for the latest version of the type to its CREATE and ALTERs and returns it in sources,
with with the corresponding obj# |
dbms_objects_utils.split_source(
tschema IN CHAR,
tname IN CHAR,
sources OUT dbms_objects_utils_tsource)
RETURN NUMBER; |
| TBD |
| |
| UPDATE_TYPES (new 11.2.0.3) |
| For each type type1 present in schema2 and schema1,
it makes any object column/table dependent on schema1.type1 point to schema2.type1 |
dbms_objects_utils.update_types(
schema1 IN VARCHAR2,
schema2 IN VARCHAR2,
typename IN VARCHAR2,
check_update IN BOOLEAN); |
| set serveroutput on |
| |
| UPGRADE_DICT_IMAGE |
| Upgrades 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 |
dbms_objects_utils.upgrade_dict_image; |
set serveroutput on
exec dbms_objects_utils.upgrade_dict_image; |
