问题描述
我已使用以下代码在oracle中使用recyclebin实用程序...
创建表tbl1
(
一个int，
b varchar2(30)
);
插入tbl1 values(1，''Heena'');
插入tbl1 values(2，''Jackline'');
删除表tbl1;
从回收站中选择*;
上面的查询没有给我任何错误.
但是删除表后，我的回收站仍然为空.
我正在使用SQLPlus Oracle 10g ...
我什至试过
ALTER SYSTEM SET recyclebin = ON;
ALTER SYSTEM SET"_recyclebin" = true范围=两者；
上面的查询说系统已更改"，但是... :(
任何人都可以在这里帮助我... ...谢谢...
I have used the following code to use the recyclebin utility in oracle...
create table tbl1
(
a int,
b varchar2(30)
);
insert into tbl1 values(1,''Heena'');
insert into tbl1 values(2,''Jackline'');
drop table tbl1;
select * from recyclebin;
The above queries dont give me any error.
But after deleting the table, my recyclebin is still empty.
I m using SQLPlus Oracle 10g...
i even tried
ALTER SYSTEM SET recyclebin=ON;
ALTER SYSTEM SET "_recyclebin" = true scope=both;
the above queries say "System altered" but... :(
Can anyone help me here ... Thnk u ...
推荐答案
select * from recyclebin;
尝试使用
try using
SHOW RECYCLEBIN;
希望这会起作用. :)
Hope this will work. :)
flashback table Tablename to before drop;
这篇关于在Oracle中使用回收站的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！