ORA-14085: partitioned table cannot have column with LONG
datatype



ORA-14085: partitioned table cannot have column with LONG datatype..

Answer / guest

Cause: User tried to create a partitioned table with a LONG
datatype or tried to add a LONG datatype column to a
partitioned table.

Action: LONG data types are not supported with partitioned
tables. Create table without LONG column or change table to
not partitioned. If adding column, do not use LONG datatype.
If modifying attributes of a column to change data type to
LONG, 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-32578: password for SYS already specified

1 Answers  


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

1 Answers  


ORA-13502: Cannot rename SYSAUX tablespace

1 Answers  


ORA-01074: cannot shut down ORACLE; inside a login session - log off first

1 Answers  


DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint

1 Answers  






ORA-14265: data type or length of a table subpartitioning column may not be changed

1 Answers  


NNF-01004: DCE returned unspecified error string

1 Answers  


RMAN-08511: piece handle=string tag=string

1 Answers  


ORA-16072: a minimum of one standby database destination is required

1 Answers  


ORA-16182: Internal error on internal channel during remote archival

1 Answers  


QSM-02140: agg(expr) requires correspondng SUM(expr*expr) function

1 Answers  


ORA-09802: Conversion of binary label to string failed.

1 Answers  


Categories