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>
分享到:
相关推荐
Recover_Truncate_data.recover_table(tgtowner, tgttable, tgtowner, rectab, tgtowner, rsttab, datadir, datadir, recfile,datadir, copyfile, blksz); end; 第七步:查看输出内容和构造表名: 15:32:...
存储过程包Fy_Recover_Data 利用Oracle表扫描机制、数据嫁接机制恢复TRUNCATE或者损坏数据的工具包
recover data, find losting files 数据恢复 数据挽救
http://www.hellodba.com/download/FY_Recover_Data.zip
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 ...
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 ...
数据恢复大师
ORACLE常用命令 一、ORACLE的启动和关闭 1、在单机环境下 要想启动或关闭ORACLE系统必须首先切换到ORACLE用户,如下 su - oracle a、启动ORACLE系统 oracle>svrmgrl SVRMGR>connect internal SVRMGR>startup ...
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 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 ...
中文版数据恢复软件 很好很强大,无论是不小心删除掉,还是格式化,重新分区,他都能完全的给你找回来,有了它,你就是电脑高手了
word recover word recover word recover word recover v
一片有关oracle 闪回恢复原理知识的书,为巩固基础知识,数据原理详解。
详细介绍如何正常删除Oracle 数据库表空间数据文件,OFFLINE和OFFLINE DROP的区别,OS级别删除了数据文件后的恢复,删除数据库表空间数据文件演示示例
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电子教材
Oracle12c RAC Restore Recover 备份恢复 从集群数据库备份、OCR备份、OCR恢复、数据库多种场景下恢复都做了讲解 适合Oracle初学者,可根据文档内脚本命令,跟着教学,逐步掌握Oracle12C集群数据库备份和恢复等知识...
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 1z0-031 教材 Scripts 只要執行 setup\\9iAdvRMAN.cmd 即可安裝上課環境
Recovery for Oracle Recovery for Oracle Recovery for Oracle Recovery for Oracle Recovery for Oracle