My Oracle Support Banner

ORA-00972 when executing Dbms_wm.recovermigratingtable After Database Upgrade (Doc ID 2356007.1)

Last updated on APRIL 08, 2022

Applies to:

Workspace Manager - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version, Core Workspace Server

When attempting to upgrade DB from 10.2.0.4 to 11.2.0.4
the following error occurs.

ERROR
-----------------------
SQL> execute wmsys.owm_mig_pkg.AllLwEnableVersioning ;
BEGIN wmsys.owm_mig_pkg.AllLwEnableVersioning ; END;

*
ERROR at line 1:
ORA-20194: Atleast one table failed during lwEnableVersioning. Please query
all_wm_vt_errors view to get the errors
ORA-01720: opc?o de concess?o n?o existe para 'WMSYS.WM$WORKSPACES_TABLE'
ORA-06512: na "WMSYS.WM_ERROR", linha 324
ORA-06512: na "WMSYS.WM_ERROR", linha 340
ORA-06512: na "WMSYS.OWM_MIG_PKG", linha 329
ORA-06512: na linha 1

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.