"truncate table, alter table, select statements will not generate any undo data.."

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

please explain?
Who is Participating?
rbrookerConnect With a Mentor Commented:

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 :)
dbaseekAuthor Commented:
i would appreciate that
I altered a table and lost all the data on that table , anyway to undo this
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.