Friday 13 April 2012

ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at the table level

ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at the table level

Cause: An attempt was made to specify a VARRAY|OPAQUE column to be stored as LOB at the partition or subpartition or template level. However the VARRAY|OPAQUE column was not specified to be stored as LOB at the table level when the table was created.

Action: Specify the VARRAY | OPAQUE column to be stored as LOB at the table level when the table is created. Alternatively, do not specify the VARRAY | OPAQUE column to be stored as LOB at the partition or subpartition or template level if it is not specified at the table level when the table is created.

No comments:

Post a Comment