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-02524: Authentication: privilege check failed

1 Answers  


PLW-05004: identifier string is also declared in STANDARD or is a SQL builtin

1 Answers  


DRG-11717: attempt to add Related Term string to non-Preferred Term string

1 Answers  


DRG-10504: primary key is required when using the DETAIL_DATASTORE

1 Answers  


DRG-10752: DEFAULT_INDEX_MEMORY cannot be greater than MAX_INDEX_MEMORY

1 Answers  


ORA-33265: (DBERRBSZ) Analytic workspace string cannot be opened. Tablespace blocksize number does not match database cache size number.

1 Answers  


ORA-02803: Retrieval of current time failed

1 Answers  


ORA-23425: invalid materialized view identifier string

1 Answers  


ORA-31027: Path name or handle string does not point to a resource

1 Answers  


ORA-00053: maximum number of enqueues exceeded

1 Answers  


ORA-27102: out of memory

1 Answers  


ORA-23302: application raised communication failure during deferred RPC

1 Answers  


Categories