Hi Amar/Matt,
I don't see how deleting records from the table before dropping it would help. The drop table statement does not produce rollback for the records that exist in the partitions, I think the issue is with the amount of rollback generated within the data dictionary.
Maybe dropping the partitions individually via the alter table ... drop partition may help.
Regards,
Rob

>>> Amar Kumar Padhi <[Email Address Removed] 05/31/01 04:04PM >>>
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 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 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