ORA-22342: dependent VARRAY column exceeds the maximum
inline column size



ORA-22342: dependent VARRAY column exceeds the maximum inline column size..

Answer / guest

Cause: An attempt was made to alter a type (add or modify
attribute) which causes the size of its dependent VARRAY
column to exceed the maximum inline column size. However,
the VARRAY column was not specified to be stored as LOB at
the table level when the table was created.

Action: Specify the VARRAY column to be stored as LOB 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

RMAN-08589: channel string: starting datafile conversion

1 Answers  


ORA-26048: Scoped REF column has wrong table name.

1 Answers  


ORA-04016: sequence string no longer exists

1 Answers  


ORA-39119: worker process interrupt for delete worker processes call by master process

1 Answers  


ORA-01186: file string failed verification tests

1 Answers  


ORA-12926: FORCE LOGGING option already specified

1 Answers  


ORA-16194: Modifying DB_UNIQUE_NAME requires SID='*' qualifier

1 Answers  


ORA-17508: I/O request buffer ptr is not alligned

1 Answers  


ORA-32817: message system link string is not configured with a log queue for string

1 Answers  


ORA-07825: sspsck: $QIO failure at AST level

1 Answers  


QSM-02090: SELECT includes an expression that is not just a column

1 Answers  


ORA-06950: No error

1 Answers  


Categories