Solved

undo

Posted on 2006-11-02
3
1,241 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
3 Comments
 

Author Comment

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

Accepted Solution

by:
rbrooker earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Case Statement in SQL Delminted Query 9 56
JDeveloper 12c for 32 bit 4 36
T-SQL Convert to PL/SQL 23 62
Oracle DATE Column Space 11 45
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now