While select is running , run the drop/ truncate command
947991Sep 24 2012 — edited Sep 27 2012I have a table created with 79 L Rows, In One session I have run select statement , and in another after ~2 sec I run the truncate command for the same table , query come out with ORA-08103: object no longer exists
Now with the same steps , I run the drop command after 2 sec, Now I get all the 79 L Rows , Now question Arises How ? I think when we drop the table , it goes into the recycle bin and from there we are getting data.
To Verify above , Now I run the command drop with purge and query come out with ORA-08103: object no longer exists.
Please let me know if I am wrong.
Regards
Sourabh Gupta