Click here to Skip to main content
15,889,335 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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 ...
Posted
Updated 28-Jul-11 20:43pm
v2

Instead of
SQL
select * from recyclebin;

try using
SQL
SHOW RECYCLEBIN;


Hope this will work. :)
 
Share this answer
 
SQL
flashback table Tablename to before drop;
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900