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

ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE

1 Answers  


ORA-24413: Invalid number of sessions specified

1 Answers  


ORA-01322: No such table

1 Answers  


IMG-00814: fail queue free failed

1 Answers  


NNC-00401: program interface initialization failed

1 Answers  


ORA-12824: INSTANCES DEFAULT may not be specified here

1 Answers  


ORA-06790: TLI Driver: poll failed

1 Answers  


ORA-29804: missing DATA keyword

1 Answers  


ORA-06113: NETTCP: Too many connections

1 Answers  


ORA-00132: syntax error or unresolved network name 'string'

1 Answers  


ORA-24316: illegal handle type

1 Answers  


ORA-16512: parameter exceeded maximum size limit

1 Answers  


Categories