Huge one, it is due to insufficient rollback segs. You must have created one
big segment for such jobs. Try using it. If that is not feasible, another
option would be to delete bunch of records with commits. This would take
some time but should not hang. Finally drop the table.

more options list...

rgds
amar

-----Original Message-----
From: Matt [mailto:[Email Address Removed] Thursday, May 31, 2001 6:48 PM
To: Amar Kumar Padhi
Cc: LazyDBA.com Discussion
Subject: Re: hanging drop table command..


Hi,

I think this page has sorted out the problem

http://www.inquiry.com/techtips/oracle_pro/10min/10min0301/10min0301-4.asp

About 1500 partitions containing 1.5 mil rows.

Is there a quick way of droping tables ?

Regards

Matt

Amar Kumar Padhi wrote:

> to confirm, are you getting this error while dropping the table?
> How many rows are there in the table?
>
> rgds
> amar
>
> -----Original Message-----
> From: Matt [mailto:[Email Address Removed] Sent: Thursday, May 31, 2001 6:26 PM
> To: Amar Kumar Padhi
> Cc: LazyDBA.com Discussion
> Subject: Re: hanging drop table command..
>
> Hi Amar and all...
>
> Ok how would I correct this error
>
> *** SESSION ID:(5.1) 2001-05-31 14:33:06.423
> *** 2001-05-31 14:33:06.423
> SMON: following errors trapped and ignored:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01555: snapshot too old: rollback segment number 2 with name "RBS1"
too
> small
>
> Help
>
> Regards
>
> Matt
>
> Amar Kumar Padhi wrote:
>
> > 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] > Sent: 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] > 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