Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to recover just one datafile/tablespace "until cancel"?

Re: Is it possible to recover just one datafile/tablespace "until cancel"?

From: Thomas Schwickert <schwickert_at_yahoo.com>
Date: Tue, 30 Sep 2003 11:58:39 +0000 (UTC)
Message-ID: <175e798aa64862e9dd4fda3297d7062d.20305@mygate.mailgate.org>

"Stan Brown" <stanb_at_panix.com> wrote in message news:bl9q7f$qj2$1_at_reader2.panix.com

> Is it possible to recover _just one_ datafile (which coantins one
> tablespace) using the until cancel option. The instnace is 7.3.4.5 if it
> matters.
>
> If this is possible, could someone give me example ayntax, I seem to not
> understand it.

Hi,

no, it isn't possible. The UNTIL CANCEL option is only for database recovery.
What you want requieres

-- recover your database with until cancel (e.g on another system)
-- export your wanted data 
-- import it in your original system

Hth
Thomas

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Sep 30 2003 - 06:58:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US