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

TNS-12544: TNS:contexts have different wait/test functions

1 Answers  


TNS-00211: Total Active Pumps : number

1 Answers  


ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 Answers  


ORA-02830: Segment could not be split - no free segments available

1 Answers  


DRG-10599: column is not indexed

1 Answers  






TNS-00546: control failure

1 Answers  


DRG-12507: stop word string already exists in this stoplist

1 Answers  


ORA-39302: schema clone operation failed

1 Answers  


ORA-09913: Malloc of dummy name failed.

1 Answers  


ORA-38900: missing mandatory column "string" of error log table "string"

1 Answers  


RMAN-08122: keep attributes for the backup are changed

1 Answers  


ORA-31022: Element not found

1 Answers  


Categories