Hi,

Make sure there are no active transactions on the table.
Then truncate the table, and then drop it. If the table is partitioned,
you should truncate the partitions first, then drop the table. Just be
careful, when you truncate, there's no going back!

Good luck
Susan

----- Original Message -----
From: "Matt" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, May 31, 2001 10:12 AM
Subject: hanging drop table command..


> Hi
>
> What does one do when a table does not wish to be droped ?
>
> And the drop table command appears to hang ?
>
> Regards
>
> Matt
>
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page