Link to home
Create AccountLog in
Avatar of taaz
taaz

asked on

oracle 11gr2 update,rollback,undo tablespace, logfile

When I update a table that impact 10,000+ rows,
How the undo tbs  handle this?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

What information are you looking for?

The docs have just about everything you need on undo.

I suggest you start here:
http://docs.oracle.com/cd/E11882_01/server.112/e10897/storage.htm#ADMQS063
SOLUTION
Avatar of Alex [***Alex140181***]
Alex [***Alex140181***]
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of taaz

ASKER

Just to clarify the concept;
I run the update that impacted 1000's of rows and changed data.
Before change data image is recorded in the undo tbs.
Any data change is also recorded in the logfile.

I do not commit and run the rollback

how oracle will react to this?
if undo tbs was not able to record all the before change image.
what happen to the data that is recorded in the logfile?
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of taaz

ASKER

Thanks