i am creating on partition table with help of the interval (numtoymintervel) then create the 4 partitions.
Now i am drop the table without drop the partition's. then i will check in user_tab_partitions. that 4 partitions are creating with systable names like(BIN$SBOS9FoWLgrgU2sUE6z+MQ==$0).
so now, how i drop the that 4 partitions. please advice them. as well as i am using
ALTER TABLE BIN$SBOS9FoWLgrgU2sUE6z+MQ==$0 DROP PARTITION EOD1;
IT'S NOT WORKING. PLEASE ADVICE ME.
THANK YOU,
VAMSHIDHARREDDY.P
This is called the recyclebin.
You dropped a table, and just in case this was an accident, we didnt *really* drop it, we just renamed it. (Similar to when you delete files on the PC and you put them in the Recycle Bin, or Trash).
If you want to empty the recycle bin you can do:
SQL> purge recyclebin
or if you want drop something without it even going to the recyclebin, then you can do:
SQL> drop table MY_TABLE purge
when you issue the drop command.
Hope this helps.
https://docs.oracle.com/database/121/ADMIN/schema.htm#ADMIN014