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
Messages: 75
Registered: February 2005

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.

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: 63923
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.


[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: Tue Oct 25 21:35:13 CDT 2016

Total time taken to generate the page: 0.16852 seconds