Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-38312: original name is used by an existing object
- 3 Answers
- 10637 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 3 Yes | 1 No |
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
| Is This Answer Correct ? | 1 Yes | 0 No |
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;
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-00221: error on write to controlfile
ORA-07440: WMON process terminated with error
ORA-23372: type string in table string is unsupported
NZE-28797: invalid key data type
ORA-26500: error on caching "string"."string"
ORA-17619: max number of processes using I/O slaves in a instance reached
ORA-28671: UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole
ORA-40219: apply result table string is incompatible with current operation
ORA-22990: LOB locators cannot span transactions
NZE-29023: The buffers are not empty.
TNS-12665: NLS string open failed
ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
Oracle Errors 
