ORA-01555 caused by SQL statement

Asked By h.archer11 200 points N/A Posted 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.

Thanks.

 

• Status: Open
• Question Views: 2167
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Sam Michaels 0 points N/A #84906

ORA-01555 caused by SQL statement

Greetings,

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.

Cheers,
Sam.

About Sam Michaels

Questions
0

Answers
4

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/19/2011
• Question Category: Oracle Database