Re: disable recyclebin?

  • From: "Ricardo Rivas" <ricardorivas2007@xxxxxxxxx>
  • To: ganstadba@xxxxxxxxxxx,Oracle-L@xxxxxxxxxxxxx
  • Date: Tue, 19 Apr 2011 14:29:56 +0000

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@xxxxxxxxxxx>
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Date: Tue, 19 Apr 2011 10:17:21 
To: <Oracle-L@xxxxxxxxxxxxx>
Reply-To: ganstadba@xxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of TESTAJ3@xxxxxxxxxxxxxx
Sent: Tuesday, April 19, 2011 9:55 AM
To: Oracle-L@xxxxxxxxxxxxx
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




Other related posts: