Best way to DROP Table?

Toad for Oracle
1

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….

2

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.

3

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.

4

There’s a purge option on that ‘drop table’ dialog that
bypasses the recycle bin.

5

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

6

Hi Steve,

On 16/02/12 15:58, Booth.Steve wrote:

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?

Pre Oracle 10G:
drop table WHATEVER cascade constraints;

10g onwards:
drop table WHATEVER cascade constraints purge;

--
Cheers,
Norm. [TeamT]

7

Take it to a very secluded canyon and drop it off a cliff. So says the Oracle.

On Thu, Feb 16, 2012 at 8:21 AM, Norman Dunbar wrote:

Hi Steve,

On 16/02/12 15:58, Booth.Steve wrote:
> 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?

Pre Oracle 10G:
drop table WHATEVER cascade constraints;

10g onwards:
drop table WHATEVER cascade constraints purge;

–
Cheers,
Norm. [TeamT]

8

That could get you in trouble for littering. Anyone remember Alice’s
Restaurant?

Nate Schroeder

Enterprise Services - Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. B2SB - Saint Louis, MO - 63167

314-694-2592

9

I barely remember that, but yup… a fat chubby abusive cook/owner with
Alice usually getting the better of him.

10

“That’s not the name of the restaurant; that’s the name of the
song. That’s why I call it, ‘Alice’s Restaurant’.”

J

Daniel B Madvig
Campus Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg

11

Since no one else said it – I miss Flo and her saying “Kiss my
grits!” J

12

That’s a great song.

I love the part about looking for a place to put the garbage – with the
dump being closed on Thanksgiving. “There, at the bottom of the cliff, we
saw another pile of garbage! We figured one big pile is better than two little
piles, and rather than bring that one up, we decided to throw ours down.”

I grew up in San Antonio, TX, and the radio station there would play that 20
minute long song once a year, on Thanksgiving.
image001.jpeg