Re: Problem in refresh
From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Tue, 23 Sep 2008 21:19:28 -0500
Message-ID: <de807caa0809231919kba8asc0d1b16d447467a@mail.gmail.com>
Date: Tue, 23 Sep 2008 21:19:28 -0500
Message-ID: <de807caa0809231919kba8asc0d1b16d447467a@mail.gmail.com>
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:19:28 CDT