Oracle 10G Recyclebin [message #313743] |
Mon, 14 April 2008 07:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pokhraj_das
Messages: 64 Registered: February 2008
|
Member |
![babai.74.cal@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Hi,
I have one test database. I logged in as normal user TESTEXP/TESTEXP and created one table TEST.
Then I drop the table as :-
sql> drop table TEST;
Now when i am querying user_recyclebin, no entry was there.
SQL> select * from user_recyclebin;
no rows selected
My question is-----
1. Why it not showing any entries at user_recyclebin?
2. How can I use/activate this "RECYCLEBIN" new features at Oracle 10G?
regards-
pokhraj
|
|
|
|
|
|
|
|
|
Re: Oracle 10G Recyclebin [message #313919 is a reply to message #313743] |
Tue, 15 April 2008 03:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
pokhraj_das
Messages: 64 Registered: February 2008
|
Member |
![babai.74.cal@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Thanx for the valuable comment.
Only one small confusion...
1. How can I know what is the size of my RECYCLEBIN as I have to write a script to purge the RECYCLEBIN when it will 90% full.
2. Also when I fired the following query the flashback_on column value is "NO", though the RECYCLEBIN value is "ON" as per the parameter file.
SQL> SELECT FLASHBACK_ON FROM V$DATABASE;
FLASHBACK_ON
------------------
NO
So how it will recover the table from the recyclebin when the FLASHBACK_ON value is "NO", as I am able to recover the table successfully from the recyclebin.
Please suggest....
Pokhraj.
[Updated on: Tue, 15 April 2008 03:26] Report message to a moderator
|
|
|
Re: Oracle 10G Recyclebin [message #313942 is a reply to message #313919] |
Tue, 15 April 2008 04:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1. query user_recyclebin and join it with user_segments. There is no limit to the size so there is no 90%
2. There is no relation between flashback database feature and recycle bin one. It recovers from recycle bin in the same way Windows recover from its one.
Regards
Michel
|
|
|