刚刚delete一张表,数据的前映象(before image)应该在回滚段里边。可以利用oracle imp/export工具从回滚段中找出数据。SQL> select to_char(sysdate,'yyyymmddhh24miss') from dual;
TO_CHAR(SYSDAT
--------------
20030913123008SQL> delete test1;SQL> commit;SQL> select * from test1;exp user/password file=f:\aaa tables = test1 flashback_time = '20030913123008'
TO_CHAR(SYSDAT
--------------
20030913123008SQL> delete test1;SQL> commit;SQL> select * from test1;exp user/password file=f:\aaa tables = test1 flashback_time = '20030913123008'
解决方案 »
- 该如何处理这个转换问题???
- 大家能否帮忙列一下锁表的几种典型原因
- 请教一个关于join on,form where的问题
- 怎么解决“ORA-12911: 永久表空间不能是临时表空间”?
- 请问怎样取得一条查询所得的记录总数?
- 请教Oracle的字符集
- 哪位老大能给一个PROC的makefile程序?(oracle734forunix505)的
- ORACLE中的关键字LEVEL是什么意思
- 在oracle中如何设置自增长的字段?
- 求助!登陆出现ORA-01034、ORA-27101错误
- exp/imp 需要那些文件才能运行?
- 我发现安装了Oracle8i之后,我的电脑从开机登录到启动完成变得很慢了,有几分钟时间,请问这是正常的吗?还是巧合,在这时候中了病毒了?
SQL> exp system/manager file=c:\aaa tables=test flashback_time='20031021095220'
SP2-0734: 未知的命令开头 "exp system..." - 忽略了剩余的行。
EXP命令只要在WINDOWS的CONSOLE运行就可以的
c:\> exp ...这样就行了
LRM-00101: 未知的参数名称 'flashback_time'EXP-00019: 处理参数失败,有关帮助请键入 'EXP HELP=Y'
EXP-00000: 导出终止失败
The following statements show a current value from the sample table hr.employees and then changes the value:SELECT salary FROM employees
WHERE last_name = 'Chung';
SALARY
----------
3800UPDATE employees SET salary = 4000
WHERE last_name = 'Chung';
1 row updated.SELECT salary FROM employees
WHERE last_name = 'Chung'; SALARY
----------
4000
To learn what the value was before the update, you can use the following flashback query:SELECT salary FROM employees
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' DAY)
WHERE last_name = 'Chung';
SALARY
----------
3800
To revert to the earlier value, use the flashback query as the subquery of another UPDATE statement:UPDATE employees SET salary =
(SELECT salary FROM employees
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' DAY)
WHERE last_name = 'Chung')
WHERE last_name = 'Chung';
1 row updated.SELECT salary FROM employees
WHERE last_name = 'Chung';
SALARY
----------
3800
2 as of timestamp(systimestamp - interval '1' day)
3 where test1='love';
as of timestamp(systimestamp - interval '1' day)
*
ERROR 位于第 2 行:
ORA-00933: SQL 命令未正确结束请教:是怎么回事啊