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

ORA-35578: (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF <cursor name> syntax

1 Answers  


ORA-13798: Parameter string cannot be NULL.

1 Answers  


RMAN-06113: changed archive log available

1 Answers  


ORA-06803: TLI Driver: the IPX device file could not be opened

1 Answers  


ORA-31527: could not find source column string for CDC change table string.string

1 Answers  






ORA-30431: refresh method must be ANY or INCREMENTAL or FORCE_FULL, not string

1 Answers  


ORA-02478: merge into base segment would overflow MAXEXTENTS limit

1 Answers  


ORA-06777: TLI Driver: error reading parms

1 Answers  


ORA-00253: character limit string exceeded by archive destination string string

1 Answers  


LSX-00215: value "~1S" whose total digits exceeds ~2d

1 Answers  


RMAN-08125: keep attributes for the proxy copy are deleted

1 Answers  


ORA-16725: the phase supplied to resource manager is invalid

1 Answers  


Categories