Oracle has introduced "Recycle Bin" Feature Oracle 10g to store all the dropped objects.
If any table in Oracle 10g is dropped then any associated objects to this table such as indexes,
constraints and other dependant objects are simply renamed with a prefix of BIN$$.
Testing
Go to SQL*PLUS
1) connect to database
2) Issue the command select * from tab;
you have tables called emp and dept
3) now delete dept table
5) Issue the command as shown in figure to check tables in recyclebin
6) Now recover table dept from recyclebin
7) Now check your table successfully recovered
This is use of recycle bin.
If you really don't want that table. Before flashback. Just issue following command.
your tables will deleted permanently
SQL > PURGE RECYCLEBIN
Thanks
Sagar
If any table in Oracle 10g is dropped then any associated objects to this table such as indexes,
constraints and other dependant objects are simply renamed with a prefix of BIN$$.
Testing
Go to SQL*PLUS
1) connect to database
2) Issue the command select * from tab;
you have tables called emp and dept
3) now delete dept table
4) Issue the command select * from tab;
5) Issue the command as shown in figure to check tables in recyclebin
6) Now recover table dept from recyclebin
7) Now check your table successfully recovered
This is use of recycle bin.
If you really don't want that table. Before flashback. Just issue following command.
your tables will deleted permanently
SQL > PURGE RECYCLEBIN
Thanks
Sagar
No comments:
Post a Comment