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

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

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

ORA-01275: Operation string is not allowed if standby file management is automatic.

1 Answers  

---

ORA-25292: Cannot add buffer on the specified queue

1 Answers  

---

ORA-03220: DBMS_ADMIN_PACKAGE required parameter is NULL or missing

1 Answers  

---

TNS-00525: Insufficient privilege for operation

1 Answers  

---

QSM-00795: the SQL Tuning Set repository has not been implemented

1 Answers  

---

ORA-07760: slemtr: $open failure

1 Answers  

---

ORA-19508: failed to delete file "string"

1 Answers  

---

IMG-00854: internal image data free failed

1 Answers  

---

ORA-22277: cannot use two different locators to modify the same LOB

1 Answers  

---

IMG-00517: height or width not present in parameter string

1 Answers  

---

ORA-28669: bitmap index can not be created on an IOT with no mapping table

1 Answers  

---

ORA-25244: dequeue index key not found, QUEUE string, rowid string

1 Answers  

---