ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at
the table level
- 1 Answers
- 2835 Views
- I also Faced
- E-Mail Answers
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 |
NNO-00321: statistic counter dump disabled
ORA-23373: object group "string"."string" does not exist
ORA-23347: datatype string for column string table string not supported
ORA-27034: maximum length of ORACLE_SID exceeded
ORA-13514: Metric Capture too close to last capture, group string
ORA-16179: incremental changes to "string" not allowed with SPFILE
ORA-14168: only one subpartition may be modified
ORA-25961: join index prevents dml cascade constraint operation
DRG-12213: cannot create/drop section group or sections for other user
ORA-25501: ALTER SYSTEM QUIESCE RESTRICTED command failed
ORA-07456: cannot set RESOURCE_MANAGER_PLAN when database is closed
ORA-01631: max # extents (string) reached in table string.string
Oracle Errors 
