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 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25206: enqueue failed, enqueue to exception queue string.string not permitted

1 Answers  


ORA-07747: slemrd: $READ failure

1 Answers  


ORA-30487: ORDER BY not allowed here

1 Answers  


ORA-02279: duplicate or conflicting MINVALUE/NOMINVALUE specifications

1 Answers  


NZE-29135: Seed generation for Random Number Generator failed.

1 Answers  






LPX-00272: FTP server unavailable: ~s

1 Answers  


ORA-19591: backup aborted because job time exceeded duration time

1 Answers  


SQL*Loader-00256: SORTED INDEXES option allowed only for direct path

1 Answers  


ORA-06528: Error executing PL/SQL profiler

1 Answers  


ORA-32019: The parameter SPFILE cannot be updated in the server parameter file.

1 Answers  


DRG-51029: unexpected error in stemmer expansion: %(1)

1 Answers  


DRG-11504: invalid longsize parameter of string specified

1 Answers  


Categories