ORA-02253: constraint specification not allowed here
- 3 Answers
- 17812 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 ? | 4 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 |
NNL-00254: Server-generated requests currently do not request forwarding
ORA-27484: Argument names are not supported for jobs without a program.
ORA-36779: (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
ORA-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [inhierarchy {variable | valueset}].
ORA-25117: MIN/MAX/Block Number expected
ORA-15009: ASM disk "string" does not exist
TNS-04063: Remote administration disabled in the Oracle Connection Manager instance.
NNL-01062: Cache checkpoint file name: string
ORA-16078: media recovery disabled
ORA-30031: the suspended (resumable) statement has been aborted
ORA-12094: error during online redefinition
ORA-32576: missing TYPE keyword
Oracle Errors 
