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-31194: Resource string is already deleted

1 Answers  

---

ORA-30944: Error during rollback for XML schema 'string' table string column 'string'

1 Answers  

---

ORA-01639: instance string has no thread assigned to it

1 Answers  

---

PLS-01469: ANSI standard does not permit records

1 Answers  

---

LSX-00167: defining form of "~S" must occur at the top level

1 Answers  

---

---

ORA-09354: Windows 32-bit Two-Task driver: ORACLE task unexpectedly died

1 Answers  

---

NNO-00122: invalid name, data ignored: entry: string

1 Answers  

---

ORA-06955: Number of database servers exceed limit

1 Answers  

---

RMAN-08008: channel string: starting full datafile backupset

1 Answers  

---

ORA-02707: osnacx: cannot allocate context area

1 Answers  

---

ORA-01169: DATAFILE number 1 not found. Must be present

1 Answers  

---

NID-00442: Database has been shutdown, open database with RESETLOGS option.

1 Answers  

---