Re: restore a single datafile
From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 16 Jan 2003 19:07:49 +1000
Message-ID: <MutV9.25246$jM5.67058_at_newsfeeds.bigpond.com>
Date: Thu, 16 Jan 2003 19:07:49 +1000
Message-ID: <MutV9.25246$jM5.67058_at_newsfeeds.bigpond.com>
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:_5nV9.25047$jM5.66228_at_newsfeeds.bigpond.com... < snippy pooh>
> So you might want to investigate perhaps using your cold backup to create
a
> clone of your live system, and use export and import to retrieve the data
> that way. You export from the clone, and then import into your real
system,
> having re-created an identically-named tablespace first.
>
> But I'll leave that for you to investigate.
>
Hi Gritto,
Listen to the man !!
When you investigate, check out transportable tablespaces, it'll make this last step easier.
Good Luck
Richard Received on Thu Jan 16 2003 - 10:07:49 CET