Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at
the table level
- 1 Answers
- 3355 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 |
ORA-14109: partition-extended object names may only be used with tables
ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
ORA-29327: unsupported client compatibility mode used when talking to the server
ORA-23611: tablespace "string" has more than one data file
ORA-04098: trigger 'string.string' is invalid and failed re-validation
ORA-19026: EXTRACTVALUE can only retrieve value of leaf node
ORA-36726: (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.
PCC-02436: This attribute is only valid for external LOB types (BFILEs)
ORA-19501: read error on file "string", blockno string (blocksize=string)
ORA-07406: slbtpd: invalid number.
ORA-32580: both SYS and SYSTEM passwords must be provided
ORA-03122: attempt to close ORACLE-side window on user side
Oracle Errors 
