ORA-02269: key column cannot be of LONG datatype
- 2 Answers
- 11608 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-30349: specified dimension hierarchy does not exist
QSM-02050: subquery using the ALL clause in mv
ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off
RMAN-06543: duplicate or conflicting LIST options: string and string
ORA-02725: osnpbr: cannot send break signal
PLS-00302: component 'string' must be declared
ORA-02448: constraint does not exist
ORA-36694: (XSRELTBL01) The value cannot be added to dimension workspace object.
ORA-10646: Too many recursive extensions during SYSTEM tablespace migration
ORA-01037: maximum cursor memory exceeded
ORA-22140: given size [string] must be in the range of 0 to [string]
PLS-00498: illegal use of a type before its declaration
Oracle Errors 
