The purge option is the way to go. It's only one more word to add to the statement. On Apr 19, 2011 8:56 AM, <TESTAJ3@xxxxxxxxxxxxxx> wrote: > I'm getting push to disable the recyclebin on a 10.2.0.4 database? > > I'm pushing back that its not a good idea to disable it for the entire > database but to disable for the session or do a drop table <table_name> > purge instead. > > Your thoughts? > > thanks, joe > > _______________________________________ > Joe Testa, Oracle Certified Professional > Senior Engineering & Administration Lead > (Work) 614-677-1668 > (Cell) 614-312-6715 > >