Home » RDBMS Server » Server Administration » Oracle 10G Recyclebin (Oracle 10.2.0.2.0, solaris)
Oracle 10G Recyclebin [message #313743] Mon, 14 April 2008 07:15 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

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 #313745 is a reply to message #313743] Mon, 14 April 2008 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Maybe recycle bin is not activated. See "show parameter recyclebin"
2. alter session/system recyclebin=on

Regards
Michel
Re: Oracle 10G Recyclebin [message #313748 is a reply to message #313743] Mon, 14 April 2008 07:24 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Here teh result of show parameter:-

SQL> show parameter recyclebin;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
recyclebin string off


Also one more question:-

please let me know the difference between

a) alter system and b) alter database

regards-
Pokhraj

Re: Oracle 10G Recyclebin [message #313757 is a reply to message #313748] Mon, 14 April 2008 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
alter database: modify database structure.
alter system: modify instance parameters/behaviour.

Regards
Michel
Re: Oracle 10G Recyclebin [message #313854 is a reply to message #313743] Mon, 14 April 2008 22:39 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

thanx for the reply. I helped me a lot.
Re: Oracle 10G Recyclebin [message #313906 is a reply to message #313743] Tue, 15 April 2008 02:22 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

How can i know that my recyclebin status is "ON" ?
Is there is any query for the same?

Pokhraj.
Re: Oracle 10G Recyclebin [message #313909 is a reply to message #313906] Tue, 15 April 2008 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See what you did 3 messages up.
Query v$parameter.

Regards
Michel
Re: Oracle 10G Recyclebin [message #313919 is a reply to message #313743] Tue, 15 April 2008 03:16 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

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
Michel Cadot
Messages: 64140
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
Previous Topic: urgent:file extensions
Next Topic: Oracle VMware image does not work
Goto Forum:
  


Current Time: Fri Dec 09 05:35:35 CST 2016

Total time taken to generate the page: 0.10570 seconds