Oracle Database Errors or Warnings from Error ORA-22865 to ORA-22876

SQLServerF1

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-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-22869: depth of type dependency hierarchy exceeds maximum limit
Cause: The type dependency hierarchy was structured to have depth greater than 1024.
Action: Re-structure the type dependency hierarchy to a shorter depth.

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-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-22872: OID INDEX clause not allowed on tables with primary key based object identifiers
Cause: An attempt to create an OID INDEX on a table with primary key based object identifiers.
Action: Remove the OID INDEX clause

ORA-22873: primary key not specified for primary key based object table
Cause: An attempt to create a primary key based object table without specifying a primary key
Action: Specify a primary key and retry the operation
ORA-22874: attribute “string” is not part of the type “string”
Cause: Attribute specified in the user_defined clause is not an attribute of the REF type
Action: Ensure that the name specified in the user_defined clause is the name of a valid attribute of the REF type
ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based
Cause: An attempt to drop the primary key of an object table which has a primary key based object identifier
Action: Remove the drop primary key clause
ORA-22876: this user-defined type is not allowed or it cannot be used in this context
Cause: An attempt to create a kind of user-defined type which is not allowed, or an attempt to create table columns or use default constructor with a type on which these are not supported.
Action: Ensure that the type is permitted in this context.

Above are list of Oracle Database Errors or Warnings from Error ORA-22865 to ORA-22876 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *