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),