On Tue, 18 Feb 2003 22:34:14 +0100, Glen A Stromquist wrote
(in message <qFx4a.87028$Q_1.1912694_at_news2.telusplanet.net>):
> Ronald wrote:
>> I have deleted oracle816 instance, i though backup was succesful before
>> deleting it.
>>
>> Now it's been upgraded to 817 and instance has been recreated but export
>> file is too old. I do have copies of all
>> datafiles and archive files of most recent situation in old 816 instance.
>> Is
>> there a way of recovering this data into the 817 instance ?
>>
>> Thanks
>>
>> Ronald
>>
>>
> Not sure what you mean here, are you saying you can't import the export
> file you created from 8.1.6?, because you should be able to do that
> reasonably easy, after you have created all the tablespaces the same,
> which I assume you have done as you said you already re created the
> instance in 8.1.7
>
Ronald,
you can use exp and imp but for what reason ? You said you upgraded the
database so all data is already there. Or did you mean you created a new
database with 817 ? In that case exp/imp is a good way to go although
upgrading is easier and faster.
--
With kind regards,
Ronald
http://ronr.nl/unix-dba
Received on Tue Feb 18 2003 - 23:11:55 CST
