Re: Problem in refresh
From: Shastry(DBA) <shastry17_at_gmail.com>
Date: Wed, 24 Sep 2008 08:02:40 +0530
Message-ID: <5b294dab0809231932s5a2ffe36y1fbafa2d0dcd32f@mail.gmail.com>
Date: Wed, 24 Sep 2008 08:02:40 +0530
Message-ID: <5b294dab0809231932s5a2ffe36y1fbafa2d0dcd32f@mail.gmail.com>
Thanks Dennis for your reply,
The datafile does exists but it is overwritten as the name of datafile is same in different mount points.
Thanks,
Ann
On Wed, Sep 24, 2008 at 7:49 AM, Dennis Williams < oracledba.williams_at_gmail.com> wrote:
> Ann,
>
> If that datafile doesn't exist on your backup, then you don't have it. You
> could take a fresh backup, but if the user wants the one that is 15 days
> old, that doesn't help.
>
> If you mean that the datafile only contains indexes, then your best
> alternative may be to just rebuild the indexes.
>
> There are several goodies in 10g that may be of assistance if you have them
> configured.
>
> Dennis Williams
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 23 2008 - 21:32:40 CDT