Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02253: constraint specification not allowed here
- 3 Answers
- 19460 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hala
This error occurs when you have a mistake when you write
the name of constraint for example when you write check
constraint in this manner (Status varchar2(15)
Constraint Title_Copy_Status_ch chech (Status in
('AVAILABLE,'DESTROYED','RENTED','RESERVED'))Enable
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / narendra reddy.d
EX:
CREATE TABLE SamplePK01
(
SampID NUMBER(2)
CONSTRAINT SamplePK01_SampID_PK PRIMERY KEY,
SampName VARCHAR2(20),
SampDate DATE
)
/
Instead of PRIMARY KEY,If you declare like PRIMERY KEY,U GET THE ERROR ORA-O2253
Remedy is to write the CONSTRAINT in proper manner and speling
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / guest
Cause: Constraint specification is not allowed here in the
statement.
Action: Remove the constraint specification from the statement.
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 6 No |
QSM-02091: mv references a non-repeatable or session-sensitive expression
ORA-24302: host connection in use by another thread
ORA-00087: command cannot be executed on remote instance
ORA-16756: Resource guard could not open standby readonly
ORA-29823: object being analyzed is not a table
SQL*Loader-00102: Invalid control file name on command line
SQL*Loader-00939: OCI error while string for table string partition string
ORA-30690: timeout occurred while registering a TCP/IP connection for data traffic detection
ORA-36980: (XSRELGID02) Variable workspace object must have a numeric data type.
ORA-22316: input type is not a collection type
ORA-23315: repcatlog version or request string is not supported by version string
QSM-01109: while rewriting with MV, string, table, string, migrated to query delta
Oracle Errors 
