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 and later
Information in this document applies to any platform.


On : version, Core Workspace Server

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

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


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

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