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


ORA-02269: key column cannot be of LONG datatype

Answers were Sorted based on User's Feedback



ORA-02269: key column cannot be of LONG datatype..

Answer / guest

Cause: Self-evident.

Action: Change the datatype of the column, or remove the
column from the key.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

ORA-02269: key column cannot be of LONG datatype..

Answer / suresh

We cannot add primary key constraint to that column only
not to the whole table, that means we will give primary key
to any column in the table except the column having the
long data type. If we give, we get the error ORA-02269: key
column cannot be of LONG datatype.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06008: connected to recovery catalog database

1 Answers  


NZE-28829: no cipher type specified

1 Answers  


PLS-00336: non-object-table "string" illegal in this context

1 Answers  


IMG-00833: boundary queue size exceeds expected size

1 Answers  


SQL*Loader-00949: incorrect datafile string specified for table string subpartition string

1 Answers  






ORA-31426: cannot modify active subscriptions

1 Answers  


ORA-02855: Number of requests is less than the number of slaves

1 Answers  


NNL-00049: Output in string cannot be renamed to string

1 Answers  


ORA-13702: Snapshot IDs specified by the range [string, string] are equal.

1 Answers  


SQL*Loader-00427: a field condition references a non-scalar field or a LOB field string

1 Answers  


ORA-29391: %s and string must be mandatory to create a mandatory plan directive

1 Answers  


ORA-02784: Invalid shared memory ID specified

1 Answers  






Categories