Re: restore datafile

From: <sybrandb_at_hccnet.nl>
Date: Tue, 01 Jul 2008 21:23:34 +0200
Message-ID: <ms0l6496p413lagio2tp2jara4ge843b0e@4ax.com>

On Tue, 1 Jul 2008 11:36:18 -0700 (PDT), sparks <han.brinkman_at_gmail.com> wrote:

> Need this to restore a single table

You can not use RMAN 'to restore a single table'. You would need TableSpace Poiht in Time Recovery, TSPITR, to restore a tablespace. Also you are performing incomplete recovery without recovering the database, you only restore it. Why do you think you have errors?

If you have set up flashback (as this seems to be 10g) and you have the recycle bin feature enabled, you should be capable to flashback the table,

-- 

Sybrand Bakker
Senior Oracle DBA

Received on Tue Jul 01 2008 - 14:23:34 CDT

This message: [ Message body ]
Next message: astalavista: "Slow query"
Previous message: sparks: "restore datafile"
In reply to: sparks: "restore datafile"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message