Hi All,

Fixed now bad rollback segments + to small in the first place.

For those that get stuck with this one DBA Studio is great
for 'creating' abd 'creating like' rolback segments.

I used the old command line first then checked with the
DBA Studio as it was RBS1, SYSTEM not RBS1, RBS

Regards

Matt

Amar Kumar Padhi wrote:

> 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] Sent: 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 LazyDBA home page