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-26046: REF column string expects scoped table name string; user passed in string.

1 Answers  

---

ORA-31003: Parent string already contains child entry string

1 Answers  

---

ORA-40207: duplicate or multiple function settings

1 Answers  

---

ORA-23370: table string and table string are not shape equivalent (string)

1 Answers  

---

ORA-16717: clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed

1 Answers  

---

---

ORA-07226: rtneco: unable to get terminal mode.

1 Answers  

---

SQL*Loader-00566: partial record found at end of datafile

1 Answers  

---

ORA-32307: must use FROM ONLY clause when referencing an object table

1 Answers  

---

ORA-33076: (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.

1 Answers  

---

PCB-00901: Pro*COBOL internal error condition detected (Code = number)

1 Answers  

---

NNF-04007: Error reading input file

1 Answers  

---

RMAN-08126: keep attributes for the proxy copy are changed

1 Answers  

---