• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1260
  • Last Modified:

undo

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

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

please explain?
0
dbaseek
Asked:
dbaseek
1 Solution
 
dbaseekAuthor Commented:
i would appreciate that
0
 
rbrookerCommented:
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 :)
0
 
NabilbahrCommented:
I altered a table and lost all the data on that table , anyway to undo this
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now