Oracle OWM_MIG_PKG
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID DEFINER
Dependencies
OWM_ASSERT_PKG WM$INSTEADOF_TRIGS_TABLELE WM$UDTRIG_INFO
OWM_CPKG_PKG WM$MODIFIED_TABLES WM$VERSIONED_TABLES
OWM_DDL_PKG WM$NESTED_COLUMNS_TABLE WM$VERSION_HIERARCHY_TABLE
OWM_DYNSQL_ACCESS WM$NEXTVER_TAB WM$WORKSPACES_TABLE
PLITBLM WM$REMOVED_WORKSPACES_TABLE WM_DDL_UTIL
UD_TRIGS WM$RIC_TABLE WM_ERROR
WM$CONSTRAINTS_TABLE    
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
Source {ORACLE_HOME}/rdbms/admin/owmmigs.plb
Subprograms
 
ALLLWDISABLEVERSIONING
Undocumented owm_mig_pkg.allLWDisableVersioning(to_version IN VARCHAR2);
exec wmsys.owm_mig_pkg.allLWDisableVersioning('21.1');

PL/SQL procedure successfully completed
 
ALLLWENABLEVERSIONING
Undocumented owm_mig_pkg.allLWEnableVersioning(from_version IN VARCHAR2);
exec wmsys.owm_mig_pkg.allLWEnableVersioning('20.1');

PL/SQL procedure successfully completed
 
ENABLEVERSIONTOPOINDEXTABLES
Undocumented owm_mig_pkg.enableVersionToPoIndexTables(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2);
TBD
 
FIXAUXPKCONSTRAINT
Undocumented

This procedure appears to be protected by an ACCESSIBLE BY clause
owm_mig_pkg.fixAuxPKConstraint(
schema     IN VARCHAR2,
table_name IN VARCHAR2);
exec wmsys.owm_mig_pkg.fixAuxPKConstraint('C##UWCLASS', 'SERVERS');
BEGIN wmsys.owm_mig_pkg.fixAuxPKConstraint('C##UWCLASS', 'SERVERS'); END;
*
ERROR at line 1:
ORA-20289: insufficient privileges on WMSYS owned package
ORA-06512: at "WMSYS.WM_ERROR", line 449
ORA-06512: at "WMSYS.WM_ERROR", line 463
ORA-06512: at line 2
ORA-06512: at "WMSYS.OWM_ASSERT_PKG", line 215
ORA-06512: at "WMSYS.OWM_ASSERT_PKG", line 27
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 572
ORA-06512: at line 1
 
FIXMETADATA
Undocumented owm_mig_pkg.fixMetadata(
table_name    IN VARCHAR2,
status_table  IN VARCHAR2,
operationmode IN NUMBER,
where_clause  IN VARCHAR2);
TBD
 
FIXPKCONSTRAINT
Undocumented

This procedure appears to be protected by an ACCESSIBLE BY clause
owm_mig_pkg.fixPKConstraint(
schema     IN VARCHAR2,
table_name IN VARCHAR2);
conn / as sysdba

exec wmsys.owm_mig_pkg.fixPKConstraint('C##UWCLASS', 'SERVERS');
BEGIN wmsys.owm_mig_pkg.fixPKConstraint('C##UWCLASS', 'SERVERS'); END;
*
ERROR at line 1:
ORA-20289: insufficient privileges on WMSYS owned package
ORA-06512: at "WMSYS.WM_ERROR", line 449
ORA-06512: at "WMSYS.WM_ERROR", line 463
ORA-06512: at line 2
ORA-06512: at "WMSYS.OWM_ASSERT_PKG", line 215
ORA-06512: at "WMSYS.OWM_ASSERT_PKG", line 27
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1529
ORA-06512: at line 1
 
FIXWMMETADATA
Undocumented owm_mig_pkg.fixWMMetadata(from_version IN VARCHAR2);
exec wmsys.owm_mig_pkg.fixWMMetadata('20.1');

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
------ ----------------- -------------- --------------------
SYS    ORA$_ATSK_AUTOSTS  JOB           18-AUG-2021 23:45:24
WMSYS  OWM_VSCRIPT_PKG    PACKAGE BODY  18-AUG-2021 23:50:16
WMSYS  LT_CTX_PKG         PACKAGE BODY  18-AUG-2021 23:50:19
WMSYS  LTADM              PACKAGE BODY  18-AUG-2021 23:50:19
WMSYS  LTRIC              PACKAGE BODY  18-AUG-2021 23:50:23
WMSYS  LTPRIV             PACKAGE BODY  18-AUG-2021 23:50:22
WMSYS  OWM_MIG_PKG        PACKAGE BODY  18-AUG-2021 23:50:15
WMSYS  LT                 PACKAGE BODY  18-AUG-2021 23:50:17
WMSYS  LTI                PACKAGE BODY 1 8-AUG-2021 23:50:22

Related Topics
Built-in Functions
Built-in Packages
Database Security
OWM_ASSERT_PKG
OWM_BULK_LOAD_PKG
OWM_CPKG_PKG
OWM_DDL_PKG
OWM_DML_PKG
OWM_DYNSQL_ACCESS
OWM_IEXP_PKG
OWM_MP_PKG
OWM_VSCRIPT_PKG
OWM_VT_PKG
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx