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

DRG-50952: Section is not PATH section group

1 Answers  


ORA-15051: file 'string' contains string error(s)

1 Answers  


ORA-40104: invalid training data for model build

1 Answers  


PLS-00509: Implementation Restriction : Pass a returned record to a temporary identifier before selecting a field

1 Answers  


ORA-07579: spini: $DCLEXH failure

1 Answers  






ORA-39054: missing or invalid definition of the SQL output file.

1 Answers  


TNS-00535: Failed to send or receive disconnect message

1 Answers  


ORA-29323: ALTER DATABASE SET COMPATIBILITY command not supported by string

1 Answers  


LFI-00121: Only one of REPLACE, or PROT allowed for opty.

1 Answers  


ORA-24406: API mode switch is disallowed when a call is in progress.

1 Answers  


ORA-33219: (CINSERT05) %K cannot be added to workspace object because it is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.

1 Answers  


PLS-00506: User Defined Constrained Subtypes are disallowed

1 Answers  


Categories