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] 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