Re: disable recyclebin?

From: Ricardo Rivas <ricardorivas2007_at_gmail.com>
Date: Tue, 19 Apr 2011 14:29:56 +0000
Message-ID: 1950668540-1303223397-cardhu_decombobulator_blackberry.rim.net-544372648-_at_bda2322.bisx.prod.on.blackberry>



Is some kind of replication involved? I believe tools like GoldenGate cannot handle the recycle bin, in particular restoring from the recycle bin.

Ricardo Rivas
Sent via BlackBerry by AT&T

-----Original Message-----
From: Michael McMullen <ganstadba_at_hotmail.com> Sender: oracle-l-bounce_at_freelists.org Date: Tue, 19 Apr 2011 10:17:21
To: <Oracle-L_at_FreeLists.org>
Reply-To: ganstadba_at_hotmail.com
Subject: RE: disable recyclebin?

What's the push? People don't like to see all the BIN$ tables in a tool? I guess my argument would be to the user that they have the option of not using the recyclebin by using purge so why should I disable for the entire db. They have the option to turn it off/on as they seem fit which seems pretty good to me.  


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com
Sent: Tuesday, April 19, 2011 9:55 AM
To: Oracle-L_at_FreeLists.org
Subject: disable recyclebin?  

I'm getting push to disable the recyclebin on a 10.2.0.4 database?

I'm pushing back that its not a good idea to disable it for the entire database but to disable for the session or do a drop table <table_name> purge instead.

Your thoughts?

thanks, joe



Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 19 2011 - 09:29:56 CDT

Original text of this message