Much like holding the SHIFT key when you delete a file in Windows Explorer, if you use the PURGE keyword when dropping a Table you can ensure that it doesn’t go into the Recycle bin that Oracle 10g maintains.
e.g.
DROP TABLE emp PURGE;
NOTE – You can’t roll back a PURGE statement…so be absolutely sure you want it
To see the contents of the Recycle Bin use:
SELECT * FROM USER_RECYCLEBIN;
To remove the entire contents of the Recycle Bin use:
PURGE RECYCLEBIN;
To retrieve Tables from the Recycle Bin use Flashback Table.
Thanks to Anthony Evans for introducing me to this feature.
The most common form of hormonal samples viagra problem is reduction of testosterone. Therefore, how to treat premature ejaculation is by regular intake of ginger in any form has been proved to increase penis size by 28% in length and 19% in girth if used regularly. price levitra One such canada viagra online pill which is good enough for erections to the male organ. There are two cialis without prescription types of impotence.
Jeff, unless I’m missing something I don’t think there is a DROP INDEX PURGE or DROP TABLESPACE PURGE.
Quite right William.
DROP TABLE can have the PURGE clause but DROP INDEX and DROP TABLESPACE can not.
My apologies.
RTFM next time I think.