Answer / guest

Cause: An attempt was made to recover an object preserving
the original name, but that name is taken up by some other
object.

Action: use the RENAME clause to recover the object with a
different name.

Please add more information about this Error

Answer / sivadasan

I faced this kind of error while Undrop a table from
recyclebin.

If i droped a table means in recyclebin it will get a new
name in the prefix with 'BIN$'.not only one. there are two
or more object name will be created.

At the time of "flashback" process Oracle is throwing this
error " ORA-38312: original name is used by an existing
object" .

If anybody know the reason pls explain

Answer / sonali

It happens because you have a table with the same name which you have dropped earlier. Now the same name table you are trying recover and in the result oracle server is giving the above error.
However you can fix it by the below command.
FLASHBACK TABLE DEPT TO BEFORE DROP RENAME TO DEPT_OLD;

ORA-36682: (XSDPART20) Partition name string appears twice.

1 Answers  

---

QSM-02005: named view in FROM list

1 Answers  

---

QSM-00794: the statement can not be stored due a violation of the string filter

1 Answers  

---

RMAN-20209: duplicate datafile name

1 Answers  

---

RMAN-06510: RMAN retention policy is set to recovery window of number days

1 Answers  

---

ORA-27365: job has been notified to stop, but failed to do so immediately

1 Answers  

---

ORA-13011: value is out of range

1 Answers  

---

ORA-33456: (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.

1 Answers  

---

ORA-22621: error transfering an object from the agent

1 Answers  

---

ORA-40205: invalid setting name string

1 Answers  

---

PROC-00030: Oracle Cluster Registry IDs do not match

1 Answers  

---

QSM-01097: Materialized view with grouping sets has too long key

1 Answers  

---