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