Oracle | DBMS_OBJECTS

Oracle DBMS_OBJECTS_UTILS Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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.

AUTHID CURRENT_USER

Dependencies

COL$	OBJ$	TYPE$
COLTYPE$	REGISTRY$HISTORY	USER$
DBMS_OUTPUT	SOURCE$

Documented No

First Available Not known but ~2007

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsobj.sql

Subprograms

DELETE_ORPHAN_TYPEIDCOLS	PERSISTABLE_DOWNGRADE_CHECK	UPGRADE_DICT_IMAGE
FIX_KOTTD_IMAGES

DELETE_ORPHAN_TYPEIDCOLS

Clean up all orphaned entries in col$. Read source code notes dbms_objects_utils.delete_orphan_typeidcols;

exec dbms_objects_utils.delete_orphan_typeidcols;

      

      PL/SQL procedure successfully completed.

FIX_KOTTD_IMAGES

Undocumented dbms_objects_utils.fix_kottd_images;

exec dbms_objects_utils.fix_kottd_images;

      

      PL/SQL procedure successfully completed.

PERSISTABLE_DOWNGRADE_CHECK

Undocumented dbms_objects_utils.persistable_downgrade_check RETURN NUMBER;

SELECT dbms_objects_utils.persistable_downgrade_check;

      

      PERSISTABLE_DOWNGRADE_CHECK

      ---------------------------

                                0

UPGRADE_DICT_IMAGE

Upgrades the type dictionary images from version 8.0 to 8.1
Deprecated dbms_objects_utils.upgrade_dict_image;

exec dbms_objects_utils.upgrade_dict_image;

      No type dictionary table to upgrade

      

      PL/SQL procedure successfully completed.