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

PLS-00150: found: string but expected : INTEGER

1 Answers  


ORA-29266: end-of-body reached

1 Answers  


ORA-31055: A null XMLType element cannot be inserted into RESOURCE_VIEW

1 Answers  


TNS-01157: Can only listen on number addresses - ignoring string

1 Answers  


UDE-00014: invalid value for parameter, 'string'.

1 Answers  






DRG-12505: error while adding or removing a stop word

1 Answers  


ORA-23392: could not find materialized view to be associated with "string"."string"

1 Answers  


ORA-19020: invalid dereference of XMLType columns

1 Answers  


NNO-00615: disabling DEFAULT-FORWARDERS-ONLY mode

1 Answers  


TNS-00095: * to trace_on - argument is considered the trace level

1 Answers  


DRG-12013: This method has already been performed - repeat operation?

1 Answers  


ORA-09797: Failed to get O/S MAC privileges.

1 Answers  


Categories