ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at
the table level
- 1 Answers
- 2706 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-02422: missing or invalid schema element
TNS-01169: The listener has not recognized the password
PLS-00484: redundant exceptions 'string' and 'string' must appear in same exception handler
RMAN-06403: could not obtain a fully authorized session
PLS-00521: ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF.
PLS-00732: Illegal overload of ellipsis in formal parameter list
RMAN-20205: incomplete UNTIL clause
ORA-04066: non-executable object, string
NNL-00224: Scheduled statistic counters to be logged in string
ORA-06260: NETNTT: cannot write to remote process
LFI-00102: Unable to seek in sequentially accessed file.
RMAN-02003: unrecognized character: string
Oracle Errors 
