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..

Answer / guest

Cause: An attempt was made to specify a VARRAY|OPAQUE column
to be stored as LOB at the partition/subpartition/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/subpartition/template
level if it is not specified at the table level when the
table is created.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13010: an invalid number of arguments has been specified

1 Answers  


ORA-09758: osnipn: could not check port in name server.

1 Answers  


ORA-13429: invalid xCoefficients or yCoefficients parameter(s)

1 Answers  


ORA-32830: result code string returned by Messaging Gateway agent

1 Answers  


ORA-32167: No payload set on the Message

1 Answers  


TNS-01202: Missing the dba group (string) specified by DBA_GROUP in SID_DESC

1 Answers  


ORA-32625: illegal dimension in cell reference predicate

1 Answers  


PLS-00160: AUTHID must specify CURRENT_USER or DEFINER

1 Answers  


ORA-19212: no key columns specified before call to DBMS_XMLSTORE.updateXML()

1 Answers  


ORA-09265: spwat: error temporarily suspending process

1 Answers  


NNO-00058: cannot load topology data from configuration database

1 Answers  


RMAN-06467: could not translate DBA: number

1 Answers  


Categories