RE: Best way to DROP Table?

Thanks. For some reason, I'd never noticed that. Just blind, I guess.

Or maybe I've just been trained to never really delete anything if you don't have to.

-- jim

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of John Dorlon
Sent: Thursday, February 16, 2012 10:11 AM
To: [email protected]
Subject: RE: [TOAD] Best way to DROP Table?


There's a purge option on that 'drop table' dialog that bypasses the recycle bin.
From: [email protected] [mailto:[email protected]] On Behalf Of Hudson, James - DNR
Sent: Thursday, February 16, 2012 10:09 AM
To: [email protected]
Subject: RE: [TOAD] Best way to DROP Table?

That should still leave it in the recycle bin for a while. So if you really want it gone, purge the recycle bin, too. Schema Browser, as usual.
________________________________
From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of John Dorlon
Sent: Thursday, February 16, 2012 10:03 AM
To: [email protected]<mailto:[email protected]>
Subject: RE: [TOAD] Best way to DROP Table?

Just drop it.  Find it in the SB LHS and hit the delete key.  Check both options.
I don't think it's any faster to truncate it first, if that is what you are asking.
From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Booth.Steve
Sent: Thursday, February 16, 2012 9:58 AM
To: [email protected]<mailto:[email protected]>
Subject: [TOAD] Best way to DROP Table?

Quick Oracle Question: If I have a huge table and I want it to be gone, destroyed, zilch nada.
What's the fastest way to get rid of it?
Thanks,
Steve....