Oracle8 Error Messages
Release 8.0.4

A58312-01

Library

Product

Contents

Index

Prev Prev Next

22850-22879: Object SQL DDL Messages

ORA-22850: duplicate LOB storage option specified

Cause: A LOB store option (CHUNK, PCTVERSION, CACHE, NOCACHE, TABLESPACE, STORAGE, INDEX) was specified more than once.

Action: Specify all LOB store options only once.

ORA-22851: invalid CHUNK LOB storage option value

Cause: The specified CHUNK LOB storage option value must be an integer.

Action: Choose an appropriate integer value and retry the operation.

ORA-22852: invalid PCTVERSION LOB storage option value

Cause: The specified PCTVERSION LOB store option value must be an integer.

Action: Choose an appropriate integer value and retry the operation.

ORA-22853: invalid LOB storage option specification

Cause: A LOB storage option was not specified.

Action: Specify one of (CHUNK, PCTVERSION, CACHE, NOCACHE, TABLESPACE, STORAGE, INDEX) as part of the LOB storage clause.

ORA-22854: invalid option for LOB storage index

Cause: A valid LOB store index option was not specified.

Action: Specify one of (INITTRANS, MAXTRANS, TABLESPACE, STORAGE) as part of the LOB storage index.

ORA-22855: optional name for LOB storage segment incorrectly specified

Cause: The optional name for LOB storage segment was specified with multiple columns in the column list.

Action: Specify each column LOB storage only with optional name(s).

ORA-22856: cannot add columns to object tables

Cause: An attempt was made to add columns to an object table. Object tables cannot be altered to add columns since its definition is based on an object type.

Action: Create a new type with additional attributes, and use the new type to create a object table. The new object table will have the desired columns.

ORA-22857: cannot modify columns of object tables

Cause: An attempt was made to alter the object table by modifying existing columns. An object table cannot be altered to modify existing columns since it is based on an object type. The table definition must be in sync with the corresponding type.

Action: Create a new type with additional attributes, and use the new type to create an object table. The new object table will have the desired columns.

ORA-22858: invalid alteration of datatype

Cause: An attempt was made to modify the column type to object, REF, nested table, VARRAY or LOB type.

Action: Create a new column of the desired type and copy the current column data to the new type using the appropriate type constructor.

ORA-22859: invalid modification of columns

Cause: An attempt was made to modify an object, REF, VARRAY, nested table, or LOB column type.

Action: Create a new column of the desired type and copy the current column data to the new type using the appropriate type constructor.

ORA-22860: object type expected

Cause: An attempt was made to create an object table using a non-object type, or to create a column that is a REF to a non-object type.

Action: Use a valid object type in the table or column definition.

ORA-22861: invalid user-defined type

Cause: An attempt was made to create a column or object table of a non-existent type

Action: Specify a valid type in table or column definition.

ORA-22862: specified object identifier doesn't match existing object identifier

Cause: An attempt was made to specify an object identifier for the type that does not match the existing identifier of the incomplete type of the same name.

Action: Specify the correct object identifier or leave it out of the statement.

ORA-22863: synonym for datatype name.name not allowed

Cause: An attempt was made to use a synonym specification for a datatype.

Action: Do not use the synonym specification for the data type.

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.

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-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-22868: table with LOBs contains segments in different tablespace

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: An attempt was made to perform ALTER TYPE with REPLACE option a non-object type.

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




Prev

Top

Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index