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-03020: asynhronous RPC test will take 1 minute

1 Answers  


ORA-27371: jobs of type EXECUTABLE are not supported on this platform

1 Answers  


RMAN-06108: changed datafile copy unvailable

1 Answers  


ORA-06028: NETASY: unable to intialise for logging

1 Answers  


NNO-00609: warning: forwarder number address length number exceeds maximum of number, ignored

1 Answers  






LRM-00117: syntax error at 'string' at the start of input

1 Answers  


NID-00401: Must finish REVERT changes before attempting any database operation.

1 Answers  


ORA-36261: (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.

1 Answers  


TNS-12538: TNS:no such protocol adapter

1 Answers  


ORA-24007: invalid value string, MAX_RETRIES should be non-negative integer

1 Answers  


RMAN-06594: platform name 'string' specified in TO PLATFORM is not valid

1 Answers  


ORA-16203: Unable to interpret skip procedure return values

1 Answers  


Categories