CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_OBJECT_UTILS
Version 11.1
 
General
Note: This procedure 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. The source code is fully exposed for both package header and body.
Source {ORACLE_HOME}/rdbms/admin/dbmsobj.sql
First Available 11.1
Security Model Owned by SYS and no privileges are granted
 
UPGRADE_DICT_IMAGE
See note above dbms_object_utils.upgrade_dict_image;
exec dbms_object_utils.upgrade_dict_image;
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [221 users online]    © 2010 psoug.org