Re: 01555 and select statement

niy38_at_hotmail.com wrote:
> I had ora-01555 error with a stored procedure. The code is like this:
> [snipped]
> 2) my rollback tablespace just have less than 30 percentage usage,
> by the way, database is 9.2.0.5 and use undo.
>
> how to improve this code or how to tune my database?

If 9i then get rid of the rollback segments and the rollback tablespace. Get with the current technology which is using an UNDO tablespace.

Information on this can be found at http://tahiti.oracle.com.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org