| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Undocumented |
| AUTHID |
DEFINER |
| Dependencies |
| ALL_ALL_TABLES |
LT |
WM$INSTEADOF_TRIGS_TABLE_USER |
| ALL_CONSTRAINTS |
LTADM |
WM$MODIFIED_TABLES |
| ALL_INDEXES |
LTDEFINER |
WM$NESTED_COLUMNS_TABLE |
| ALL_LOBS |
LTRIC |
WM$NEXTVER_TAB |
| ALL_OBJECTS |
LTUTIL |
WM$REMOVED_WORKSPACES_TABLE |
| ALL_TABLES |
LT_CTX_PKG |
WM$RIC_TABLE |
| ALL_TAB_COLS |
LT_EXPORT_PKG |
WM$RIC_TRIGGER_TABLE_USER |
| ALL_TAB_PRIVS |
OWM_ASSERT_PKG |
WM$UDTRIG_INFO_USER |
| ALL_USERS |
OWM_CPKG_PKG |
WM$VERSIONED_TABLES |
| ALL_VIEWS |
OWM_DDL_PKG |
WM$VERSIONED_TABLES_USER |
| DBA_RECYCLEBIN |
OWM_DYNSQL_ACCESS |
WM$VERSION_HIERARCHY_TABLE |
| DBA_ROLE_PRIVS |
PLITBLM |
WM$WORKSPACES_TABLE |
| DBA_TABLESPACES |
UD_TRIGS |
WM_DDL_UTIL |
| DBMS_LOCK |
WM$CONSTRAINTS_TABLE |
WM_ERROR |
| DBMS_STANDARD |
|
|
|
| Documented |
No |
| Exceptions |
| Error Code |
Reason |
| ORA-20299 |
tablespace WMTBSP does not exist |
|
| First Available |
Not known |
| Security Model |
Owned by WMSYS with no privileges granted
Access to some subpograms prevented by an Accessible By clause. |
| Source |
{ORACLE_HOME}/rdbms/admin/owmmigs.plb |
| Subprograms |
|
| |
| ALLLWDISABLEVERSIONING |
| Undocumented |
owm_mig_pkg.allLWDisableVersioning(to_version IN VARCHAR2); |
exec wmsys.owm_mig_pkg.allLWDisableVersioning('23.4');
PL/SQL procedure successfully completed |
| |
| ALLLWENABLEVERSIONING |
| Undocumented |
owm_mig_pkg.allLWEnableVersioning(from_version IN VARCHAR2); |
exec wmsys.owm_mig_pkg.allLWEnableVersioning('23.4');
PL/SQL procedure successfully completed |
| |
| ENABLEVERSIONTOPOINDEXTABLES |
| Undocumented |
owm_mig_pkg.enableVersionToPoIndexTables(
topo_owner IN VARCHAR2,
topo_name IN VARCHAR2); |
| TBD |
| |
| FIXAUXPKCONSTRAINT |
| Undocumented |
owm_mig_pkg.fixAuxPKConstraint(
schema IN VARCHAR2,
table_name IN VARCHAR2); |
exec wmsys.owm_mig_pkg.fixAuxPKConstraint('C##UWCLASS', 'SERVERS');
*
ORA-20289: insufficient privileges on WMSYS owned package |
| |
| FIXMETADATA |
| Undocumented |
owm_mig_pkg.fixMetadata(
table_name IN VARCHAR2,
status_table IN VARCHAR2,
operationmode IN NUMBER,
where_clause IN VARCHAR2); |
| TBD |
| |
| FIXPKCONSTRAINT |
| Undocumented |
owm_mig_pkg.fixPKConstraint(
schema IN VARCHAR2,
table_name IN VARCHAR2); |
conn / as sysdba
exec wmsys.owm_mig_pkg.fixPKConstraint('C##UWCLASS', 'SERVERS');
*
ORA-20289: insufficient privileges on WMSYS owned package |
| |
| FIXWMMETADATA |
| Undocumented |
owm_mig_pkg.fixWMMetadata(from_version IN VARCHAR2); |
exec wmsys.owm_mig_pkg.fixWMMetadata('23.4');
PL/SQL procedure successfully completed |
| |
GRANT_SELECT (new 23ai)  |
| Good question what this does but one thing it definitely does not do is raise an exception when given the name of a non-existent table |
owm_mig_pkg.grant_select(table_owner IN VARCHAR2); |
conn wmsys/wmsys
exec owm_mig_pkg.grant_select('ZZYZX');
PL/SQL procedure successfully completed |
| |
| MODIFYSYSTEMTRIGGERS |
| Undocumented |
owm_mig_pkg.modifySystemTriggers(flag IN VARCHAR2); |
| TBD |
| |
| MOVE WM METADATA |
| Undocumented |
owm_mig_pkg.moveWMMetadata(new_tablespace IN VARCHAR2); |
exec wmsys.owm_mig_pkg.moveWMMetadata('WMTBSP');
PL/SQL procedure successfully completed |
| |
| RECOMPILEALLOBJECTS |
| Undocumented |
owm_mig_pkg.recompileAllObjects; |
exec wmsys.owm_mig_pkg.recompileAllObjects;
PL/SQL procedure successfully completed. |
| |
| RECOMPILETABLEOBJECTS |
| Undocumented |
owm_mig_pkg.recompileTableObjects(
schema IN VARCHAR2,
table_name IN VARCHAR2,
vt_option IN NUMBER); |
| TBD |
| |
| RECOVERMIGRATINGTABLE |
| Undocumented |
owm_mig_pkg.recoverMigratingTable(
table_owner_var IN VARCHAR2,
table_name_var IN VARCHAR2,
ignore_last_error IN BOOLEAN); |
| TBD |
| |
| RECREATEPTUPDDELTRIGGERS |
| Undocumented |
owm_mig_pkg.recreatePTUpdDelTriggers; |
exec wmsys.owm_mig_pkg.recreatePTUpdDelTriggers;
PL/SQL procedure successfully completed.
SELECT owner, object_name, object_type, last_ddl_time
FROM dba_objects
WHERE last_ddl_time > sysdate-1/96;
OWNER OBJECT_NAME
OBJECT_TYPE LAST_DDL_TIME
-------- ---------------------------- ---------------- --------------------
AUDSYS AUD$UNIFIED TABLE PARTITION 07-MAY-2024 19:16:30
AUDSYS SYS_IL0000021921C00030$$ INDEX PARTITION 07-MAY-2024 19:16:30
AUDSYS SYS_IL0000021921C00031$$ INDEX PARTITION 07-MAY-2024 19:16:30
AUDSYS SYS_IL0000021921C00097$$ INDEX PARTITION 07-MAY-2024 19:16:30
AUDSYS SYS_IL0000021921C00113$$ INDEX PARTITION 07-MAY-2024 19:16:30
AUDSYS SYS_LOB0000021921C00030$$ LOB PARTITION 07-MAY-2024 19:16:30
AUDSYS SYS_LOB0000021921C00031$$ LOB PARTITION 07-MAY-2024 19:16:30
AUDSYS SYS_LOB0000021921C00097$$ LOB PARTITION 07-MAY-2024 19:16:30
AUDSYS SYS_LOB0000021921C00113$$ LOB PARTITION 07-MAY-2024 19:16:30
SYS ORA$_ATSK_SMFLUSH JOB 07-MAY-2024 19:19:46
SYS SYS_IL0000008762C00009$$ INDEX PARTITION 07-MAY-2024 19:16:46
SYS SYS_LOB0000008762C00009$$ LOB PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS TABLE PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_DETAILS TABLE PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_DETAILS_IDX01 INDEX PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_DETAILS_IDX02 INDEX PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_DETAILS_IDX03 INDEX PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_IDX01 INDEX PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_IDX02 INDEX PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_IDX03 INDEX PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_TIME_BANDS TABLE PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_TIME_BANDS_IDX01 INDEX PARTITION 07-MAY-2024 19:16:46
SYS WRP$_REPORTS_TIME_BANDS_IDX02 INDEX PARTITION 07-MAY-2024 19:16:46
WMSYS LT PACKAGE 07-MAY-2024 19:16:13
WMSYS LT PACKAGE BODY 07-MAY-2024 19:17:27
WMSYS LTADM PACKAGE BODY 07-MAY-2024 19:17:28
WMSYS LTDEFINER PACKAGE BODY 07-MAY-2024 19:17:29
WMSYS LTI PACKAGE BODY 07-MAY-2024 19:17:30
WMSYS LTUTIL PACKAGE BODY 07-MAY-2024 19:17:28
WMSYS LT_CTX_PKG PACKAGE BODY 07-MAY-2024 19:17:28
WMSYS LT_CTX_PKG PACKAGE 07-MAY-2024 19:16:13
WMSYS OWM_DDL_PKG PACKAGE 07-MAY-2024 19:16:13
WMSYS OWM_MIG_PKG PACKAGE BODY 07-MAY-2024 19:16:13 |