| General Information |
| Purpose; |
Provides routines to compile all types and reset type version during downgrade. |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmstypu.sql |
| Dependencies |
| COMPILE_ALL_TYPES |
RESET_ALL_TYPES |
UPGRADE_ALL_TABLES |
| DELETE_CONSTRUCTOR_KEYWORD |
|
|
|
| Security Model |
Owned by SYS with no granted privileges |
| |
| COMPILE_ALL_TYPES |
Undocumented
Overload 1 |
dbms_type_utility.compile_all_types; |
| exec dbms_type_utility.compile_all_types; |
| Overload 2 |
dbms_type_utility.compile_all_types(ownername IN VARCHAR2); |
| exec dbms_type_utility.compile_all_types('UWCLASS'); |
| |
| RESET_ALL_TYPES |
Undocumented
Overload 1 |
dbms_type_utility.reset_all_types; |
| exec dbms_type_utility.reset_all_types; |
| 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'); |
