Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

QSM-01054: no join match between query and summary, string

1 Answers  


SQL*Loader-00626: Character set conversion buffer overflow.

1 Answers  


ORA-13265: geometry identifier column string in table string is not of type NUMBER

1 Answers  


ORA-01355: logminer tablespace change in progress

1 Answers  


PLS-00993: Cursor Variables cannot be passed as RPC arguments or results

1 Answers  






ORA-06529: Version mismatch - PL/SQL profiler

1 Answers  


CLSR-00004: Error encountered at string, category=number, operation=string, OS error=number

1 Answers  


NPL-00311: cannot end constructed ASN.1 encoding, string encoding octets unread

1 Answers  


ORA-01230: cannot make read only - file string is offline

1 Answers  


ORA-21600: path expression too long

1 Answers  


ORA-13029: Invalid SRID in the SDO_GEOMETRY object

1 Answers  


LFI-00111: No other flags allowed in fixed length format.

1 Answers  






Categories