Re: ANNOUNCE: DBD::Oracle 1.22 Release Candidate 3

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/