Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to recover just one datafile/tablespace "until cancel"?
In <175e798aa64862e9dd4fda3297d7062d.20305_at_mygate.mailgate.org> "Thomas Schwickert" <schwickert_at_yahoo.com> writes:
>"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
Not meaning to challenge your GURUness :-) but is this an issue of my Oracle version being to old (7.3.4.5)? As some other people have sugested that I can do a recover until cancel on a specific datafile.
I'm genuinly interested in using this catastrophe as a learning experience, so please be gentel :-)
Thanks for the education.
-- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin FranklinReceived on Tue Sep 30 2003 - 07:28:17 CDT