Oracle | OWM_MIG

Oracle OWM_MIG_PKG Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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	FIXPKCONSTRAINT	RECOMPILEALLOBJECTS
ALLLWENABLEVERSIONING	FIXWMMETADATA	RECOMPILETABLEOBJECTS
ENABLEVERSIONTOPOINDEXTABLES	MODIFYSYSTEMTRIGGERS	RECOVERMIGRATINGTABLE
FIXAUXPKCONSTRAINT	MOVEWMMETADATA	RECREATEPTUPDDELTRIGGERS
FIXMETADATA

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