Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

unable upgrade 11.2.0.3.0 to 18c : workspace manager ORA-20000

Hi to all,

We are running on 11.2.0.3 in a Linux el7uek and we are planning to upgrade from 11.2.0.3.0 to 18C but we are facing error:


ORA-20000: All versioned table must have a 'VERSIONED' status before upgrading.


but all tables are versioned:


SQL> select table_name, owner, disabling_ver from wmsys.wm$versioned_tables;


TABLE_NAME           OWNER             DISABLING_VER

------------------------------ ------------------------------ -------------

UTATESTRUCT1          ALMACEN            VERSIONED

UTATTOPOGRA4          ALMACEN            VERSIONED

UTGEOMAGR           ALMACEN            VERSIONED

RELUTNOMDOCAT1         ALMACEN            VERSIONED

... ... ...

¿any idea?

Help will be appreciated.


Regrads.


Rob.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center