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>


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-l
Received on Tue Sep 23 2008 - 21:32:40 CDT

Original text of this message