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-31089: schema "string" does not target namespace "string"

1 Answers  

---

TNS-00038: INTCTL: Poorly formed address or command string

1 Answers  

---

ORA-12200: TNS:could not allocate memory

1 Answers  

---

EXP-00072: error closing export file string

1 Answers  

---

ORA-02840: Open of log file by client failed

1 Answers  

---

NNL-00550: flush [<server_list>] : flush one or more servers' cache(s)

1 Answers  

---

ORA-06536: IN bind variable bound to an OUT position

1 Answers  

---

NID-00138: Block verification failed for datafile string (number)

1 Answers  

---

ORA-06136: NETTCP: error during connection handshake

1 Answers  

---

EXP-00022: must be SYS or SYSTEM to do incremental export

1 Answers  

---

ORA-01070: Using an old version of Oracle for the server

1 Answers  

---

ORA-30558: internal error [string] in function based index

1 Answers  

---