Usage: drop table
eg: drop table emp purge;
2.How to delete a table from recycle bin?
Usage: purge < table name >
eg: purge emp;
3. How to recover a table from recycle bin?
Usage: flashback table "HBKLOEKIMO$#^^&777" to before drop;
Usage1:flashback table "HBKLOEKIMO$#^^&777" to before drop rename to emp1;
4.How to remove all objects in recyclebin?
Usage: purge recyclebin
5. How to show all objects in recyclebin?
Usage: show recyclebin
1 comment:
sir, plz tell me how to make table tempoary in oracle 10g
Post a Comment