Database - RAC/Scalability (MOSC)

MOSC Banner

How to migrate an Dictionary object type from 11g (on solaris) to 12c (on linux)

We are trying to upgarde an Oracle Databaje 11g on RAC (Solaris) to Oracle Database 19c on RAC (unix)

We are getting the following error:

ORA-39083: Object type TABLE:"REPGOLD"."ET$015C7A870002" failed to create with error:

ORA-06564: object REPGOLD_DATA does not exist


Failing sql is:

CREATE TABLE "REPGOLD"."ET$015C7A870002" ("ACCOUNT_EX_ID" NUMBER, 

"ACCOUNT_FK" NUMBER, 

"TARIFF_PLAN" VARCHAR2(512 CHAR), 

"FIELD_BOOL" NUMBER(1,0),

 "VOUCHER_BAR" NUMBER(1,0),

 "VOUCHER_TRIES" NUMBER(38,6),

 "VOUCHER_BAR_DATE" TIMESTAMP (3) WITH TIME ZONE,

 "VOUCHER_BAR_COUNT" NUMBER(38,6),

 "CATEGORY" VARCHAR2(512 CHAR),

 "LAST_MOD_DATE" TIMESTAMP (3) WITH TIME ZONE,

 "BILL_CYCLE_DATE" VARCHAR2(10 CHAR),

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