On Thu, 04 Sep 2008 11:01:17 -0400, John Scoles <[EMAIL PROTECTED]> wrote: > H.Merijn Brand wrote: > > On Wed, 30 Jul 2008 18:00:52 -0400, John Scoles <[EMAIL PROTECTED]> > > wrote: > > > >> Ok hot off the press RC3 > >> > >> A few more minor fixed but a last minute patch for ora_lob_chunk_size > >> function > >> > >> It can be found in the usual spot > >> > >> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.22-RC3.tar > > > > <rant>What really pisses me off in Oracle 10 (beside all the normal > > Oracle hate) is the new (mis)feature of a Recyle Bin. WTF, a database > > is not a windows system!</rant> > > > > That said, I think it would be neat if DBD::Oracle would clean up the > > recycle bin after it has done it's testing. > > > <RERANT>Unfortunately this is way to far on the Oracle DBA side to be > part of DBD::Oracle, One has to do the Purge command while logged in as > a user with 'SYSTEM' privs or greater. It would also Purge ie (empty, > delete, erase kill) the entire Recycle Bin something that may tick off > you friendly neighborhood DBA.
I would so much love to be able to type SQL > PURGE ORACLE CASCADING CONSTRAINTS INCLUDING HISTORY; and see it actually work. > As well this is a (mis)feature can be turned off or on so one would have > to test for that then test to see if the user has purge etc. > > Not something I think one should introduce in DBD::Oracle. I think it > would result in a loss of confidence in DBI and DBD as we would start > doing SYSTEM type work on table space right from the start. OK, a friendly warning then? (/me just typed "ALTER DATABASE FLASHBACK OFF;" and added recyclebin = OFF to the .ora startup file) > cheers > John Scoles > > >> Cheers and thanks for all the help guys -- H.Merijn Brand Amsterdam Perl Mongers http://amsterdam.pm.org/ using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00, 11.11, 11.23, and 11.31, SuSE 10.1, 10.2, and 10.3, AIX 5.2, and Cygwin. http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
