ORA-14113: partitioned table cannot have column with LOB
datatype



ORA-14113: partitioned table cannot have column with LOB datatype..

Answer / guest

Cause: User tried to create a partitioned table with a LOB
datatype or tried to add a LOB datatype column to a
partitioned table.

Action: LOB data types are not supported with partitioned
tables. Create table without LOB column or change table to
not partitioned. If adding column, do not use LOB datatype.
If modifying attributes of a column to change data type to
LOB, it has to be a non partitioned table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00604: Invalid attribute value '~1S', for attribute '~2s'.

1 Answers  


ORA-24010: QUEUE string does not exist

1 Answers  


LPX-00115: element "~1S" is missing required attribute "~2S"

1 Answers  


KUP-04084: The ORACLE_DATAPUMP access driver does not support the ROWID column.

1 Answers  


ORA-02430: cannot enable constraint (string) - no such constraint

1 Answers  


ORA-00054: resource busy and acquire with NOWAIT specified

1 Answers  


ORA-00448: normal completion of background process

1 Answers  


DRG-12603: CTXSYS does not own user datastore procedure: string

1 Answers  


ORA-07513: sscgctl: $deq unexpected return on cancel of term. lock

1 Answers  


ORA-24270: a row already exists in the string table for these parameters

1 Answers  


ORA-06804: TLI Driver: could not bind an IPX address at initialization

1 Answers  


DRG-10550: illegal syntax for index, preference, source or section name

1 Answers  


Categories