Thursday, 15 March 2012

ORA-14114: partitioned table cannot have column with object, REF, nested table, array datatype

ORA-14114: partitioned table cannot have column with object, REF, nested table, array datatype

Cause: User tried to create a partitioned table with a object datatype (object, REF, nested table, array) or tried to add a object datatype column to a partitioned table.

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

No comments:

Post a Comment