We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

undo

dbaseek
dbaseek asked
on
Medium Priority
1,268 Views
Last Modified: 2012-06-22
"truncate table, alter table, select statements will not generate any undo data.."

What does it means " will not generate any undo data"?

please explain?
Comment
Watch Question

Author

Commented:
i would appreciate that
Top Expert 2006
Commented:
Hi,

undo data is used to rollback a statement prior to that statement being committed.

these commands are "non-recoverable" commands. they contain an implicit commit, once thay have completed, they cannot be rolled back.

if you truncate a table by mistake, you may be able to use flashback to get that table back, but this is not the same as rolling back a transaction.
alter table is a DML statement, these also contain an implicit commit, once the change has been made, it cannot be rolled back.  you can issue another change to undo what you did, eg, drop column after add column, but these are 2 statements, the second is not a rollback of the first.
selects do not create undo as they are not making changes to data contained within the table.

good luck :)

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
I altered a table and lost all the data on that table , anyway to undo this
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.