Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02253: constraint specification not allowed here
- 3 Answers
- 19438 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 |
ORA-16719: unable to query V$ARCHIVE_DEST fixed view
LSX-00212: value "~1s" whose total digits exceeds ~2d
ORA-06040: NETDNT: invalid login (connect) string
ORA-01178: file string created before last CREATE CONTROLFILE, cannot recreate
DRG-13000: error while adding or removing a sub lexer
ORA-29394: session id string and serial# string do not exist
ORA-01678: parameter string must be pairs of pattern and replacement strings
ORA-16511: messaging error using ksrget
ORA-29269: HTTP server error string
TNS-12560: TNS:protocol adapter error
ORA-25251: exceeded maximum number of recipients for message
LSX-00146: element or attribute is improperly defined
Oracle Errors 
