Oracle DBMS_TYPE_UTILITY
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 Provides routines to compile all types and reset type version during downgrade.
AUTHID DEFINER
Dependencies
DBMS_OUTPUT SOURCE$ USER$
OBJ$ TYPE$ _ACTUAL_EDITION_OBJ
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmstypu.sql
Subprograms
 
COMPILE_ALL_TYPES
Compile all types in the database
Overload 1
dbms_type_utility.compile_all_types;
exec dbms_type_utility.compile_all_types;
Compile all types within a schema
Overload 2
dbms_type_utility.compile_all_types(ownername IN VARCHAR2);
exec dbms_type_utility.compile_all_types('UWCLASS');
 
DELETE_CONSTRUCTOR_KEYWORD
Undocumented dbms_type_utility.delete_constructor_keyword;
exec dbms_type_utility.delete_constructor_keyword;
 
RESET_ALL_TYPES
Reset database types during downgrade
Overload 1
dbms_type_utility.reset_all_types;
exec dbms_type_utility.reset_all_types;
Reset schema types during downgrade
Overload 2
exec dbms_type_utility.reset_all_types(ownername IN VARCHAR2);
exec dbms_type_utility.reset_all_types('UWCLASS');
 
UPGRADE_ALL_TABLES
Undocumented
Overload 1
dbms_type_utility.upgrade_all_tables;
exec dbms_type_utility.upgrade_all_tables;
Overload 2 exec dbms_type_utility.upgrade_all_tables(ownername IN VARCHAR2);
exec dbms_type_utility.upgrade_all_tables('UWCLASS');

Related Topics
Packages
TYPES
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