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-12083: must use DROP MATERIALIZED VIEW to drop "string"."string"

1 Answers  

---

ORA-16128: User initiated shut down successfully completed

1 Answers  

---

DRG-12219: section name missing

1 Answers  

---

NCR-03002: NCRO: Maximum number of contexts has been reached

1 Answers  

---

ORA-30195: reserved for future use

1 Answers  

---

ORA-12233: TNS:Failure to accept a connection

1 Answers  

---

ORA-08206: ora_addr: cannot translate address file name

1 Answers  

---

ORA-09318: slkhst: unable to host out to operating system

1 Answers  

---

ORA-19585: premature end of volume on piece string

1 Answers  

---

ORA-32502: Cannot execute command. Flash Freeze is not in effect

1 Answers  

---

ORA-09708: soacon: failed to bind socket to port.

1 Answers  

---

DRG-50926: invalid text query string

1 Answers  

---