Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02253: constraint specification not allowed here
- 3 Answers
- 19316 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-00347: log string of thread string, expected block size string doesn't match string
NNL-01056: Requests forwarded: number
ORA-26520: internal memory failure
ORA-16074: ARCH processes must be active
ORA-23372: type string in table string is unsupported
ORA-07227: rtneco: unable to set noecho mode.
ORA-12630: Native service operation not supported
ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.
TNS-00130: Failed to create Interchange's internal address
ORA-13188: cell decode failed
ORA-02298: cannot validate (string.string) - parent keys not found
ORA-32575: Explicit column default is not supported for modifying views
Oracle Errors 
