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-24056: internal inconsistency for QUEUE string and destination string

1 Answers  

---

ORA-01698: a clone database may only have SYSTEM rollback segment online

1 Answers  

---

ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT

1 Answers  

---

DRG-11129: the rule table is empty

1 Answers  

---

DRG-10900: out of memory

1 Answers  

---

ORA-22627: tc [string] must be that of object/varray/nested table

1 Answers  

---

ORA-22880: invalid REF

1 Answers  

---

ORA-07290: sksagdi: specified directory for archiving does not exist.

1 Answers  

---

NNL-00236: Statistic counter reset interval is currently string

1 Answers  

---

PLS-00319: subquery in an IN or NOT IN clause must contain exactly one column

1 Answers  

---

NZE-29156: conditional RNG self-test failure

1 Answers  

---

ORA-28043: invalid bind credentials for DB-OID connection

1 Answers  

---