ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

Cause: An attempt to perform ALTER TYPE with REPLACE option for a pure incomplete type

Action: Completely define the original type, before using the ALTER TYPE with REPLACE option.

ORA-22870: ALTER TYPE with REPLACE option a non-object type

ORA-22870: ALTER TYPE with REPLACE option a non-object type

Cause: attempt to perform ALTER TYPE with REPLACE option a non-object type

Action: drop the non-object type first, then re-create it as an object type

ORA-22869: depth of type dependency hierarchy exceeds maximum limit

ORA-22869: depth of type dependency hierarchy exceeds maximum limit

Cause: The type dependency hierarchy was structured to have depth greater than 1,024

Action: Re-structure the type dependency hierarchy to a shorter depth.

ORA-22868: table with LOBs contains segments in different tablespaces

ORA-22868: table with LOBs contains segments in different tablespaces

Cause: An attempt was made to drop a tablespace which contains the segment(s) for the LOB columns of a table but does not contain the table segment.

Action: Find table(s) with LOB columns which have non-table segments in this tablespace. Drop these tables and reissue drop tablespace.

ORA-22866: default character set is of varying width

ORA-22866: default character set is of varying width

Cause: A character LOB was defined but the default character set is not fixed width.

Action: Ensure that the character set is of fixed width before defining character LOBs.

ORA-22865: more than one column specified

ORA-22865: more than one column specified

Cause: An attempt was made to specify multiple columns where only one is allowed.

Action: Specify a single column and retry the operation.

ORA-22864: cannot ALTER or DROP LOB indexes

ORA-22864: cannot ALTER or DROP LOB indexes

Cause: An attempt was made to ALTER or DROP a LOB index.

Action: Do not operate directly on the system-defined LOB index. Perform operations on the corresponding LOB column.