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-13043: failed to read metadata from the <layer>_SDOLAYER table

1 Answers  


ORA-39015: job is not running

1 Answers  


ORA-33058: (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.

1 Answers  


ORA-00405: compatibility type "string"

1 Answers  


ORA-00203: using the wrong controlfiles

1 Answers  






ORA-22282: non-contiguous append to a buffering enabled LOB not allowed

1 Answers  


RMAN-04020: target database name "string" does not match channel's name: "string"

1 Answers  


ORA-30386: invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  


ORA-27417: BYWEEKNO clause is only supported when FREQ=YEARLY

1 Answers  


RMAN-06422: no channels found for SEND command

1 Answers  


ORA-31157: Invalid Content-Type charset

1 Answers  


Categories