ORA-02269: key column cannot be of LONG datatype
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-19765: mount id string does not match mount id string in control file
ORA-21523: functionality not supported by the server (object mode only)
NZE-28825: No cryptographic engine function specified.
ORA-13768: Snaphshot ID must be between string and string.
EXP-00074: rounding VOLSIZE down, new value is string
TNS-04002: The command completed successfully.
ORA-31498: description and remove_description cannot both be specified
ORA-16720: no available LOG_ARCHIVE_DEST_n parameters to use
PCB-00579: Invalid ARRAYLEN length variable type for "string"
PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL
QSM-02086: mv uses the MIN or MAX aggregate functions
TNS-12632: Role fetch failed