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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02399: exceeded maximum connect time, you are being logged off

1 Answers  


PCC-01014: "VARYING" not supported with PIC N PICTURE clause

1 Answers  


ORA-28542: Error in reading HS init file

1 Answers  


ORA-06908: CMX: error during transfer of ORACLE_SID

1 Answers  


LPX-00000: normal, successful completion

1 Answers  


NZE-28852: Bad password

1 Answers  


NNL-00804: Queries received, type META-DATA: number

1 Answers  


QSM-00803: The STORAGE_CHANGE parameter value string cannot be zero or negative for partial workloads.

1 Answers  


PLS-00598: comparison of object with NULL using "string" is not allowed

1 Answers  


ORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE.

1 Answers  


PLS-01467: The value list of the IN predicate, if not a subquery, must contain only value_specifications

1 Answers  


ORA-15112: No diskgroups are currently mounted.

1 Answers  


Categories