Paula, Don't forget that ORA-01555s are not caused by the query. The query is usually a victim of other processes. Google for it and you'll find the most obvious remedies, like running the query when the database isn't so busy. Dennis Williams