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-39038: Object path "string" is not supported for string jobs.

1 Answers  

---

DRG-51019: unable to open or illegal format for fuzzy match data file: string

1 Answers  

---

ORA-01090: shutdown in progress - connection is not permitted

1 Answers  

---

SQL-02141: Collection descriptor has not been allocated

1 Answers  

---

ORA-06801: TLI Driver: listen for SPX server reconnect failed

1 Answers  

---

ORA-13386: commit/rollback operation error: [string]

1 Answers  

---

ORA-06970: X.25 Driver: remote host is unknown

1 Answers  

---

QSM-02163: cannot use object id columns from materialized view log

1 Answers  

---

TNS-00018: INTCTL: TNS_ADMIN not defined

1 Answers  

---

ORA-06578: output parameter cannot be a duplicate bind

1 Answers  

---

ORA-19680: some blocks not recovered. See trace file for details

1 Answers  

---

PCC-02046: CMD-LINE: Unable to open config file:

1 Answers  

---