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>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值