ORA-22866 During Upgrade From 12c To 19c
(Doc ID 2792527.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
ORA-22866 errors were generated during database upgrade to 19c. The upgrade spool file shows:
22:52:33 SQL>
22:52:33 SQL> CREATE OR REPLACE TYPE JSON_KEY_LIST FORCE AS VARRAY(32767) OF VARCHAR2(4000);
22:52:33 2 /
CREATE OR REPLACE TYPE JSON_KEY_LIST FORCE AS VARRAY(32767) OF VARCHAR2(4000);
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
CREATE OR REPLACE TYPE JDOM_T FORCE
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
22:52:36 46 /
CREATE OR REPLACE TYPE JSON_Element_T FORCE AUTHID CURRENT_USER AS OBJECT(
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
CREATE OR REPLACE TYPE JSON_Array_T FORCE AUTHID CURRENT_USER
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
22:52:39 76 /
CREATE OR REPLACE TYPE JSON_Object_T FORCE AUTHID CURRENT_USER
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
22:52:33 SQL> CREATE OR REPLACE TYPE JSON_KEY_LIST FORCE AS VARRAY(32767) OF VARCHAR2(4000);
22:52:33 2 /
CREATE OR REPLACE TYPE JSON_KEY_LIST FORCE AS VARRAY(32767) OF VARCHAR2(4000);
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
CREATE OR REPLACE TYPE JDOM_T FORCE
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
22:52:36 46 /
CREATE OR REPLACE TYPE JSON_Element_T FORCE AUTHID CURRENT_USER AS OBJECT(
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
CREATE OR REPLACE TYPE JSON_Array_T FORCE AUTHID CURRENT_USER
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
22:52:39 76 /
CREATE OR REPLACE TYPE JSON_Object_T FORCE AUTHID CURRENT_USER
*
ERROR at line 1:
ORA-22866: cannot replace a type with table dependents
Cause
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
| Symptoms |
| Cause |
| Solution |