Re: 10g recycle bin and ALL_OBJECTS
From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 04 Feb 2008 15:28:16 -0800
Message-ID: <1202167670.527719@bubbleator.drizzle.com>
>
> Check if dba_recyclebin exists ? Or code the database version in your
> utility ?
>
> if (ora9) then
> ...
> else
> ...
> end if;
Date: Mon, 04 Feb 2008 15:28:16 -0800
Message-ID: <1202167670.527719@bubbleator.drizzle.com>
Matthias Hoys wrote:
> "Harel" <guhar1_at_yahoo.com> wrote in message
> news:54e3374f-be09-4e0f-aa10-9e4c2b6578d0_at_y5g2000hsf.googlegroups.com...
>>> dba_recyclebin view lists the objects in recyclebin. >>> Exclude those >> Ok. But then my utility would have to create two cursors, one if I am >> Ora 9 , and one if Ora 10 and +. >> Tornicated.
>
> Check if dba_recyclebin exists ? Or code the database version in your
> utility ?
>
> if (ora9) then
> ...
> else
> ...
> end if;
Why reinvent the wheel? Just use the built-in compiler flags. http://www.psoug.org/reference/dbms_db_version.html
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Feb 04 2008 - 17:28:16 CST