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

Direct access to some objects in this package is prevented by means of 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('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 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 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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx