Question

直接修改了oracle数据库的blob字段，现在xml解析不了了

本人自作聪明，直接用plsql的for update 语句，手动修改了oracle数据库blob字段中的内容，是在rtf界面修改的，然后保存了，然后现在系统解析不了xml了，请问大神们有人知道怎么还原不？急，求解！

Answer 1

恢复吧团大大！
可以通过仿扮SCN来进行恢复塌竖！

SQL> create table a1(id int,name varchar2(200));
Table created.
SQL> begin
2 for i in 1 .. 100
3 loop
4 insert into a1 values(i,'xxx');
5 end loop;
6 commit;
7 end;
8 /
PL/SQL procedure successfully completed.
SQL> select count(*) from chen;
COUNT(*)
----------
100
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
10010078
SQL> delete from a1 where id>90;
10 rows deleted.
SQL> commit;
Commit complete.
SQL> select count(*) from a1;
COUNT(*)
----------
90
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
10010440

SQL> select count(*) from a1 as of scn 10010078;
COUNT(*)
----------
100

后面的操作你自己应该懂得

Answer 2

vbv