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

RMAN-04026: unable to open a temporary file: "string"

1 Answers  


ORA-06423: NETCMN: Error in receiving data

1 Answers  


ORA-08466: raw buffer length string is too short for string

1 Answers  


LFI-00109: Unable to open file [string][string]. string.

1 Answers  


ORA-12203: TNS:unable to connect to destination

1 Answers  






NPL-00304: uninitialized ASN.1 tag attribute

1 Answers  


NZE-29008: Bad DH Param key length

1 Answers  


ORA-16127: stalled waiting for additional transactions to be applied

1 Answers  


ORA-36376: (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.

1 Answers  


ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL

1 Answers  


PCC-00117: Invalid ARRAYLEN length variable type

1 Answers  


QSM-00515: operation cancelled by user

1 Answers  


Categories