N/APosted on - 07/18/2011
I have searched the internet and can't tell if the users query fails when I see the message in the alert log. The query is coming from a user running a report in business objects. What user and what query/report I can't tell. I have been going through the audit logs in Business Objects, and I am not finding report failures corresponding to the timestamp in the alert .log which makes me think maybe the query completes even though I receive the error message.
Please tell me the reasons for this error.
ORA-01555 caused by SQL statement
This error occurs when the undo table space is low. You can try to put it in the auto extend mode but make sure that enough disk space is available to perform this and try. This will solve your error that is coming and your query will also run fast. It occurs as some jobs or other things might be using the undo table space and your query may not be getting enough undo table space that it requires. Because of these jobs and other things, you need to make sure that enough disk space is available for your query.