| Table Space (merged) [message #434060] |
Mon, 07 December 2009 01:36  |
|
|
Good Morning Gurus...
(Althugh its not a very GOOD Morning for me  ) Why because
I was running one procedure today morning and suddenly got one pop up saying "Unable to extend the table space" and message halts waiting for me to press "OK". Was beyond my capabilities to cop up with so i asked my DBA's and they did some magic behind may be an extension in table spaces and after doing this I pressed "OK" again
Jak
on my procedure which was opened and waiting for any responce from me. And after this it starts running again and finished with flying colors. now i have doubt that if i commited any sin today. I have no idea if this modus operandi was correct. If your about to suggest me to verify the data so i have to wait till a functional guy will sit me and verify... Please let me know if this error have any impact of the noraml operation of the procedure.
-
Attachment: ltaerror.jpg
(Size: 201.26KB, Downloaded 902 times)
|
|
|
|
| Re: Table Space [message #434063 is a reply to message #434060] |
Mon, 07 December 2009 01:49  |
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
|
Junior Member |
|
|
you should post more details regarding the procedure, and database versions, and host.
Are you issuing commits throughout or one at the end?
Was the procedure designed to be re-run in the event such an error occurred?
Nets Edge
|
|
|
|
| Re: Table Space [message #434068 is a reply to message #434063] |
Mon, 07 December 2009 02:01 |
|
|
Quote:Are you issuing commits throughout or one at the end?
No I have several commit in verious places.
Quote:Was the procedure designed to be re-run in the event such an error occurred?
Procedure designed to rerun in case of traditional errors like no data found and unique and all. but not for the table spaces. Why i am not sure is whenever I said "Rollabck" i am sure i am deleting everything and issing one "Go Run Again". But here in this case i have to press ok and it didnt asked me to cancel.
Anyways i will wait till the havoc and get ready my import for the DB and when enounter one i will flush the data and run the Proc again with extended tablespaces. 
Thanks
Javed
|
|
|
|
|
|
|
|
| Re: Table Space (merged) [message #434138 is a reply to message #434060] |
Mon, 07 December 2009 07:04 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Quote:Please let me know if this error have any impact of the noraml operation of the procedure.
I'm afraid we can't answer that question - we don't know what the procedure does, or how it handles exceptions.
The fact that you got an unformatted error strongly suggests that your procedure didn't do much in the way of error handling.
As to whether it as affected the noral operation - yes. It has interrupted the normal operation, and any uncommitted changes may have been lost (or may not - it largely depends on your exception handler
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
