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-24460: Native Net Internal Error

1 Answers  


TNS-00207: Uptime : number days number hr. number min. number sec

1 Answers  


ORA-31491: could not add logfile to LogMiner session

1 Answers  


ORA-16781: The status of log transport service for some database is unknown

1 Answers  


ORA-00366: log string of thread string, checksum error in the file header

1 Answers  






ORA-14634: Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table

1 Answers  


LPX-00011: In line ~1u of ~2s [general entity ~3S]:

1 Answers  


ORA-01135: file string accessed for DML/query is offline

1 Answers  


NZE-29163: Third party PKI vendor is not supported in FIPS mode.

1 Answers  


DRG-12302: invalid column list

1 Answers  


NCR-04005: NCRR: Invalid procedure handle

1 Answers  


ORA-02237: invalid file size

1 Answers  


Categories