Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: restore a single datafile
"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 - 03:07:49 CST