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-23340: incorrect resolution method string

1 Answers  


RMAN-20206: log sequence not found in the repository

1 Answers  


RMAN-06306: ====================

1 Answers  


DRG-10706: length of string exceeds maximum size of string

1 Answers  


PLS-01454: No operator may be used with values of data type CHAR

1 Answers  






ORA-02148: EXCLUSIVE specified multiple times

1 Answers  


ORA-29660: Unable to find the class defined in the EXTERNAL NAME clause

1 Answers  


ORA-28047: database is not a member of any enterprise domain in OID

1 Answers  


NNL-00404: TTL: string

1 Answers  


ORA-28273: No mapping for user nickname to LDAP distinguished name exists.

2 Answers  


ORA-19573: cannot obtain string enqueue for datafile string

1 Answers  


ORA-38737: Expected sequence number string doesn't match string

1 Answers  


Categories