Oracle | DBMS_OBJECTS

Oracle DBMS_OBJECTS_UTILS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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 dbms_objects_utils.upgrade_dict_image;

Deprecated

      

      exec dbms_objects_utils.upgrade_dict_image;

      No type dictionary table to upgrade

      

      PL/SQL procedure successfully completed.