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

ORA-25293: Remote Recipient Subsribers and buffered operations not possible for Queue string

1 Answers  


ORA-25221: enqueue failed, signature specified queue not supporting non-repudiation

1 Answers  


ORA-16732: Error executing dbms_logstdby.skip procedure

1 Answers  


SQL-01075: you are currently logged on

1 Answers  


NZE-29031: SSL handshake is required.

1 Answers  






O2F-00319: No OUTTYPE file specified

1 Answers  


ORA-16706: no resource guard is available

1 Answers  


ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table

1 Answers  


ORA-19040: Element string does not match expected string.

1 Answers  


ORA-01564: rollback segment is not PUBLIC

1 Answers  


EXP-00048: Cannot export SYSAUX Tablespace for Point-in-time Recovery or Transportable Tablespace

1 Answers  


ORA-12069: invalid object for offline instantiation

1 Answers  


Categories