ORA-00972 when executing Dbms_wm.recovermigratingtable After Database Upgrade

(Doc ID 2356007.1)

Last updated on FEBRUARY 07, 2018

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms