Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-02253: constraint specification not allowed here
- 3 Answers
- 19308 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 |
PCC-02011: found identifier greater than 128 characters (truncated)
ORA-13435: GeoRaster metadata dimension inconsistent
SQL*Loader-00252: Sort data sets are not used by SQL*Loader
ORA-24159: invalid variable definiton
ORA-12720: operation requires database is in EXCLUSIVE mode
PLS-01901: : host bind array too small
ORA-06413: Connection not open.
PLS-00458: subprogram 'string' cannot be called from a REPEATABLE subprogram
ORA-29384: number of children for plan string exceeds string
ORA-25219: enqueue failed, sequence deviation not allowed for queue string.string
ORA-19803: Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)
UDI-00052: incorrect Data Pump client for operation: string
Oracle Errors 
