Home » RDBMS Server » Server Administration » Undo TBS full, does transaction rollback or hang?
Undo TBS full, does transaction rollback or hang? [message #403379] Fri, 15 May 2009 04:34 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Hi,

Need one small clarification please.

I was dropping a column form a very large table. The transaction exited with an ORA-30036 : unable to extend segment by 8 in undo tablespace 'UNDO1'.

When i give the command to drop the column again, does oracle start from where it stopped?
My basics tell me that this transaction has been rolled back and the activity will start again.

Hope I am right!

Pls let me know.

Cheers!
KV
Re: Undo TBS full, does transaction rollback or hang? [message #403396 is a reply to message #403379] Fri, 15 May 2009 06:01 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DDL are made of one, several or many small transactions.
Where Oracle restarts is not really known and not documented.
Theorically it should restart from from the beginning, in reality you have to raise a SR and ask Oracle support.

Regards
Michel

[Updated on: Fri, 15 May 2009 06:03]

Report message to a moderator

Previous Topic: ORA-02050: transaction 8.5.5627 rolled back, some remote DBs may be in-doubt
Next Topic: How to move tablespace from logical volume to another
Goto Forum:
  


Current Time: Wed Dec 07 10:31:44 CST 2016

Total time taken to generate the page: 0.12278 seconds