Oracle DBMS_OBJECTS_UTILS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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$ DBMS_OBJECTS_UTILS_TNAME DBMS_OBJECTS_UTILS_TSOURCE
COLTYPE$ DBMS_OBJECTS_UTILS_TNAMEARR DBMS_OUTPUT
DBMS_OBJECTS_UTILS_TINFO DBMS_OBJECTS_UTILS_TSELEM  
Documented No
First Available Not known but ~2007
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmsobj.sql
Subprograms
 
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;
 
FIX_KOTTD_IMAGES
  dbms_objects_utils.fix_kottd_images;
exec dbms_objects_utils.fix_kottd_images;
 
UPGRADE_DICT_IMAGE
Upgrades the type dictionary images from 8.0 to 8.1. The dbms_objects_utils.upgrade_dict_image;
exec dbms_objects_utils.upgrade_dict_image;

Related Topics
DBMS_OBJECTS_APPS_UTILS
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
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-2017 Daniel A. Morgan All Rights Reserved