Hi,
Sometimes You can get ” ORA-38307: object not in RECYCLE BIN ” error.
Details of error are as follows.
ORA-38307: object not in RECYCLE BIN
Cause: Trying to Purge the object which is not in RecycleBin.
Action: Only the objects in RecycleBin can be PURGEDED.
You can read the following post, if you don’t know what is the Recycle bin.
What is the Recycle bin and How to Restore Dropped Tables from Recycle Bin
When you purge table, it gives the following error.
SQL> purge TABLE "BIN$Y+hPc6dSNrzgHFgARTeSFh==$0"; purge TABLE "BIN$Y+hPc6dSNrzgHFgARTeSFh==$0" * ERROR at line 1: ORA-38307: object not in RECYCLE BIN
To solve this error, you should use the SCHEMA name as follows.
SQL> purge TABLE MEHMET."BIN$Y+hPc6dSNrzgHFgARTeSFh==$0"; Table purged.
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
1,792 views last month, 1 views today
One comment
Pingback: 38307 - nyhow