Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

undo

Posted on 2006-11-02
3
Medium Priority
?
1,251 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?
0
Comment
Question by:dbaseek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Author Comment

by:dbaseek
ID: 17861204
i would appreciate that
0
 
LVL 18

Accepted Solution

by:
rbrooker earned 1500 total points
ID: 17861254
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
 

Expert Comment

by:Nabilbahr
ID: 34108620
I altered a table and lost all the data on that table , anyway to undo this
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question