Re: Restoring a Table using RMan

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 11 Jul 2004 21:03:37 +0200
Message-ID: <40f18f56$0$27296$626a14ce@news.free.fr>

"Michael" <melliott42_at_yahoo.com> a écrit dans le message de news:91721cf.0407110757.8029c88_at_posting.google.com...
> Hello All,
>
> In Orlace 8.17 I am trying to learn RMan . I have been able to
> restore a database as shown below:
> RMAN> restore database;
> RMAN> recover database;
> RMAN> alter database open;
>
> How can you restore a Table using RMan?
>
>
> Thanks,
>
> Michael

You can't.
RMAN is for physical backup/restore (database/tablespace/file/block) not logical one (table, cluster...).
To be able to restore a table you have to make a logical backup with export.

(With RMAN you can create another db make a tspitr of the tablespace containing the table and export/import it.)

Regards
Michel Cadot Received on Sun Jul 11 2004 - 14:03:37 CDT