Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-33214: (CINSERT02) The workspace object dimension is too large.

1 Answers  


SQL*Loader-00503: Error appending extension to file (string)

1 Answers  


RMAN-00601: fatal error in recovery manager

1 Answers  


PCC-01511: Identifier on line number in file string too long for code generated in file string

1 Answers  


SQL*Loader-00432: converted data too large

1 Answers  






NPL-00300: maximum ASN.1 element nesting depth string exceeded on read

1 Answers  


TNS-00212: Total Pumps Started : number

1 Answers  


PLS-00701: illegal ORACLE error number string for PRAGMA EXCEPTION_INIT

2 Answers  


ORA-30556: functional index is defined on the column to be modified

1 Answers  


NNO-00331: error saving new value string of string to the save config table.

1 Answers  


ORA-29851: cannot build a domain index on more than one column

1 Answers  


ORA-13365: layer SRID does not match geometry SRID

1 Answers  






Categories