samir25
asked on
Impact of rollback
i would like to know.
1. if a table is dropped can this statement be rolled back?
2. If in sql plus ROLLBACK is written does it mean that whatever was the previous statement that will be rolled back? (no savepoitn defined)
3. Supposing a ROLLBACK is done on sql plus prompt. and on the side line lot of other applications are using the database...does this rollback on this sql plus impact there also?
1. if a table is dropped can this statement be rolled back?
2. If in sql plus ROLLBACK is written does it mean that whatever was the previous statement that will be rolled back? (no savepoitn defined)
3. Supposing a ROLLBACK is done on sql plus prompt. and on the side line lot of other applications are using the database...does this rollback on this sql plus impact there also?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh so if a table is dropped there is no way to rollback...
thansk a lot for the explanations.
thansk a lot for the explanations.
In 10g there is a concept called recycle bin. see this link for more details.
http://www.orafaq.com/node/968
http://www.orafaq.com/node/968
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
2. All the statements until the previous COMMIT or ROLLBACK will be rolled back.
3. No. A rollback statement impacts only the changes made in the current session. You cannot rollback changes done by other transactions.