I assume it is being used. Kill sessions which are locking the table and
then drop it.

rgds
amar


-----Original Message-----
From: Matt [mailto:[Email Address Removed] Thursday, May 31, 2001 6:13 PM
To: LazyDBA.com Discussion
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] subscribe: send a blank email to oracledba-[Email Address Removed] 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