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-38494: column in the table alias and an attribute have matching names

1 Answers  

---

NNL-00856: Average rename processing time: string

1 Answers  

---

NNL-00952: Cache lookup failures: number

1 Answers  

---

NID-00507: APPEND Append to output log NO

1 Answers  

---

ORA-01031: insufficient privileges

1 Answers  

---

QSM-00796: the specified SQL statement cannot be stored in the workload because table string does not have valid statistics

1 Answers  

---

ORA-24769: cannot forget an active transaction

1 Answers  

---

ORA-07506: scgrl: $deq unexpected return on lockid string

1 Answers  

---

RMAN-05506: error during recursive execution

1 Answers  

---

ORA-36674: (XSDPART12) Invalid dimension value starting at string.

1 Answers  

---

NCR-03017: NCRO: Transport type RSLV not supported

1 Answers  

---

DRG-11400: failed to parse document with key string

1 Answers  

---