`

recover data after executing "delete " or "truncate table " in oracle

阅读更多
satyaki>
satyaki>
satyaki>select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Elapsed: 00:00:00.02
satyaki>

satyaki>
satyaki>create table Test_SAM
  2     as
  3       select * from emp;

Table created.

Elapsed: 00:00:01.06
satyaki>
satyaki>
satyaki>select count(*) from Test_SAM;

  COUNT(*)
----------
        14

Elapsed: 00:00:00.00
satyaki>
satyaki>
satyaki>delete from Test_SAM;

14 rows deleted.

Elapsed: 00:00:00.00
satyaki>
satyaki>commit;

Commit complete.

Elapsed: 00:00:00.00
satyaki>
satyaki>
satyaki>select count(*) from Test_SAM;

  COUNT(*)
----------
         0

Elapsed: 00:00:00.00
satyaki>
satyaki>insert into Test_SAM
  2     select *
  3     from Test_SAM as of timestamp(sysdate - 1/1440);

14 rows created.

Elapsed: 00:00:00.00
satyaki>
satyaki>
satyaki>commit;

Commit complete.

Elapsed: 00:00:00.00
satyaki>
satyaki>
satyaki>select count(*) from Test_SAM;

  COUNT(*)
----------
        14

Elapsed: 00:00:00.00
satyaki>
satyaki>
satyaki>truncate table Test_SAM;

Table truncated.

Elapsed: 00:00:00.05
satyaki>
satyaki>
satyaki>select count(*) from Test_SAM;

  COUNT(*)
----------
         0

Elapsed: 00:00:00.00
satyaki>
satyaki>
satyaki>insert into Test_SAM
  2     select *
  3     from Test_SAM as of timestamp(sysdate - 1/1440);
insert into Test_SAM
            *
ERROR at line 1:
ORA-01466: unable to read data - table definition has changed


Elapsed: 00:00:00.00
satyaki>
分享到:
评论

相关推荐

    oracle恢复工具-FY_Recover_Data

    Recover_Truncate_data.recover_table(tgtowner, tgttable, tgtowner, rectab, tgtowner, rsttab, datadir, datadir, recfile,datadir, copyfile, blksz); end; 第七步:查看输出内容和构造表名: 15:32:...

    Fy_Recover_Data压缩包

    存储过程包Fy_Recover_Data 利用Oracle表扫描机制、数据嫁接机制恢复TRUNCATE或者损坏数据的工具包

    recover data

    recover data, find losting files 数据恢复 数据挽救

    FY_Recover_Data.sql

    http://www.hellodba.com/download/FY_Recover_Data.zip

    Recover4all Professional

    If You are a company or other form of organization, and You wish to authorize the Registered Software to be used in a local area network or other network, You must purchase a license for each ...

    Recover 4 all Pro V2.26

    mmediately after deletion the data of deleted files is still invisibly on the disk. This fact makes it possible to recover deleted files. But in the course of disk usage by users, programs or the ...

    RecoverData.exe

    数据恢复大师

    最全的oracle常用命令大全.txt

    ORACLE常用命令 一、ORACLE的启动和关闭 1、在单机环境下 要想启动或关闭ORACLE系统必须首先切换到ORACLE用户,如下 su - oracle a、启动ORACLE系统 oracle>svrmgrl SVRMGR>connect internal SVRMGR>startup ...

    Oracle.Application.Express.Administration.For.DBAs.and.Developers.epub

    This book helps database and system administrators succeed in managing Oracle Application Express (APEX) environments. Focus is on creating the right combination of scalability, high-availability, ...

    Oracle RMAN for Absolute Beginners(Apress,2014)

    Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the ...

    POWERDATA RECOVER

    中文版数据恢复软件 很好很强大,无论是不小心删除掉,还是格式化,重新分区,他都能完全的给你找回来,有了它,你就是电脑高手了

    word recover word recover

    word recover word recover word recover word recover v

    oracle flash_recover_area(闪回恢复区)原理和实践操作

    一片有关oracle 闪回恢复原理知识的书,为巩固基础知识,数据原理详解。

    如何正确的删除Oracle表空间数据文件

    详细介绍如何正常删除Oracle 数据库表空间数据文件,OFFLINE和OFFLINE DROP的区别,OS级别删除了数据文件后的恢复,删除数据库表空间数据文件演示示例

    data recovery

    data recovery is a tool for recover those data had been delete carelessly

    Oracle 1Z0-025 Backup & Recover电子教材

    Oracle 1Z0-025 Backup & Recover电子教材Oracle 1Z0-025 Backup & Recover电子教材Oracle 1Z0-025 Backup & Recover电子教材

    Oracle12c RAC Restore Recover 备份恢复

    Oracle12c RAC Restore Recover 备份恢复 从集群数据库备份、OCR备份、OCR恢复、数据库多种场景下恢复都做了讲解 适合Oracle初学者,可根据文档内脚本命令,跟着教学,逐步掌握Oracle12C集群数据库备份和恢复等知识...

    数据恢复软件 Odin Data Recovery Professional v8.8.8.

    Odin Data Recovery Professional is a useful data recovery tool for hardware RAID and hard drive, USB drive, SD card, memory card,any removable discks,etc.It can do format recovery, unformat and ...

    Oracle 9i Backup and Recover Lab Scripts

    真正Oracle 9i Backup and Recover Lab Scripts 1z0-031 教材 Scripts 只要執行 setup\\9iAdvRMAN.cmd 即可安裝上課環境

    Recovery for Oracle

    Recovery for Oracle Recovery for Oracle Recovery for Oracle Recovery for Oracle Recovery for Oracle

Global site tag (gtag.js) - Google Analytics