Re: 10g recycle bin and ALL_OBJECTS
From: Matthias Hoys <anti_at_spam.com>
Date: Thu, 31 Jan 2008 23:56:03 +0100
Message-ID: <47a251c6$0$2981$ba620e4c@news.skynet.be>
Date: Thu, 31 Jan 2008 23:56:03 +0100
Message-ID: <47a251c6$0$2981$ba620e4c@news.skynet.be>
"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;
Received on Thu Jan 31 2008 - 16:56:03 CST