Re: DBD::Oracle puts junk into the recyclebin

From: joel garry <joel-garry_at_home.com>
Date: Mon, 7 Nov 2011 10:47:06 -0800 (PST)
Message-ID: <66f1e239-02df-4bc4-bc90-cc352ddd44f0_at_q35g2000prh.googlegroups.com>



On Nov 5, 10:16 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> I decided that it would be the right time to update my DBD::Oracle 1.28
> to the latest and the greatest version, which is 1.34. I ran "make test",
> an old habit which stuck with me since I've encountered some not so well
> tested modules, and everything was peachy. The module got properly
> installed but the recycle bin was full of junk:
>
> SQL> select owner,object_name,original_name,can_undrop,can_purge
>   2  from dba_recyclebin;
>
> OWNER OBJECT_NAME          ORIGINAL_NAME                    CAN CAN
> ----- -------------------- -------------------------------- --- ---
> SCOTT BIN$sNwS4xrmQ+rgQ2QB SYS_C0038375                     NO  YES
>       qMBihQ==$0

...

>
> SCOTT BIN$sNwX+7oIRCTgQ2QB DBD_ORA__DROP_ME                 YES YES
>       qMCF/Q==$0
>
> SCOTT BIN$sNwZmHenRC7gQ2QB DBD_ORA__DROP_ME                 YES YES
>       qMDFHA==$0
>
> 51 rows selected.
>
> Elapsed: 00:00:00.12
> SQL>
>
> Everything can be cleaned manually, but I believe that the testing
> procedure should run "purge recyclebin" at the end:
> SQL> connect scott/tiger
> Connected.
> SQL> purge recyclebin;
>
> Recyclebin purged.
>
> Elapsed: 00:00:05.21
>
> After that, there was nothing left:
>
> SQL> select object_name,original_name,can_undrop,can_purge
>   2  from user_recyclebin;
>
> no rows selected
>
> Elapsed: 00:00:00.04
> SQL>
>
> perl -e 'use DBD::Oracle;print "$DBD::Oracle::VERSION\n";'
> 1.34
>
> BTW, the Makefile.PL complained because of not being able to find demo.mk
> but I circumvented it by using the instant client which was OK. My
> version is 11.2.0.3 on Linux x86.
>
> --http://mgogala.byethost5.com

I think anything that leaves junk should clean up after itself, but not any more than that.

jg

--
_at_home.com is bogus.
http://www.signonsandiego.com/news/2011/nov/06/book-lovers-head-to-local-fair/
Received on Mon Nov 07 2011 - 12:47:06 CST

Original text of this message