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


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-15046: ASM file name 'string' is not in single-file creation form

1 Answers  


ORA-12315: database link type is invalid for the ALTER DATABASE statement

1 Answers  


DRG-11606: URL store: access to string timed out waiting for client request

1 Answers  


ORA-19999: skip_row procedure was called

1 Answers  


ORA-13217: invalid parameters supplied in ALTER INDEX statement

1 Answers  






ORA-07617: $FORMAT_CLASS failed translating the binary label to a string

1 Answers  


NID-00500: Keyword Description (Default)

1 Answers  


PLS-00522: MAP methods must return a scalar type.

1 Answers  


IMG-00555: invalid value for gamma correction

1 Answers  


SQL*Loader-00477: REF directive for field string requires at least two arguments

1 Answers  


ORA-32581: missing or invalid password

1 Answers  


ORA-30340: illegal dimension name

1 Answers  






Categories