Is it possible to find out the query which has caused the error ORA-01555 ??
------------------------------------------------------------------------ The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
I found that the select query is causing the error. But afik, selcts don't use undo segements ??
------------------------------------------------------------------------ The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
When i started off my oracle journey i aslo thought the same thing that select dont use undo.But now after years later and loosing all my hair i did realise after all i was wrong it hurt my pride badly and i am still bald :-(.
When i started off my oracle journey i aslo thought the same thing that select dont use undo.But now after years later and loosing all my hair i did realise after all i was wrong it hurt my pride badly and i am still bald :-(.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote
Originally Posted by hrishy
