Oracle wants to keep a read consistant image within the rollback segment.
Either add a big rollback segment and point your affected transaction to it
or add more rollback segments if lots of oltp is going around. Your rbs
maybe corrupted but this is a more likely scenerio
-----Original Message-----
From: Matt [mailto:[Email Address Removed] Thursday, May 31, 2001 10:26 AM
To: 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] subscribe: send a blank email to oracledba-[Email Address Removed] 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