ORA-02348: cannot create VARRAY column with embedded LOB



ORA-02348: cannot create VARRAY column with embedded LOB..

Answer / guest

Cause: An attempt was made to create a column of a VARRAY
type which has an embedded LOB attribute. The LOB could be
an attribute of a subtype of the declared type of VARRAY's
element.

Action: Remove offending attribute from type. If it is a
subtype attribute then declare the VARRAY column NOT
SUBSTITUTABLE.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

IMP-00037: Character set marker unknown

1 Answers  


ORA-14046: a partition may be split into exactly two new partitions

1 Answers  


ORA-14003: GLOBAL clause contradicts previosly specified LOCAL clause

1 Answers  


TNS-00204: Started tracing in intlsnr

1 Answers  


RMAN-06226: Automatic instance removed

1 Answers  


ORA-09210: sftopn: error opening file

1 Answers  


ORA-33022: (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.

1 Answers  


QSM-01115: rollup took place on a column with a window function

1 Answers  


ORA-01904: DATAFILE keyword expected

1 Answers  


ORA-00077: dump string is not valid

1 Answers  


ORA-15125: ASM file name 'string' contains an invalid template name

1 Answers  


ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.

1 Answers  


Categories