ORA-02331: cannot create constraint on column of datatype string



ORA-02331: cannot create constraint on column of datatype string..

Answer / guest

Cause: An attempt was made to create a constraint on a
column posessing a non-constrainable datatype -- VARRAY,
nested table, object, LOB, FILE, or REF.

Action: Change the column datatype, or remove the constraint.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00118: line string: data length string exceeds maximum of string, data ignored

1 Answers  


PLS-00645: character set mismatch found at 'string' among operands in a COALESCE expression

1 Answers  


UDE-00007: attempt to free unallocated memory

1 Answers  


ORA-30938: No prefix defined for namespace 'string' (particle string)

1 Answers  


ORA-25241: cannot change correlation ID from string to string without FIRST_MESSAGE option

1 Answers  


LPX-00312: cannot construct XML PI with content: ~S

1 Answers  


ORA-39754: FULL PARTITIONED OUTER JOIN is not supported

1 Answers  


ORA-19554: error allocating device, device type: string, device name: string

1 Answers  


TNS-04085: Password not changed since last save.

1 Answers  


NZE-29041: The callback is NULL.

1 Answers  


ORA-14320: DEFAULT cannot be specified for ADD/DROP VALUES or SPLIT

1 Answers  


RMAN-20215: backup set not found

1 Answers  


Categories