"gritto" <agrittini_at_yahoo.com> wrote in message news:<3e254898$0$227$4d4efb8e_at_read.news.it.uu.net>...
> Hi all,
> is it possible to restore a single datafile (or tablespace) from a backup by
> attaching the file ??
> I've dropped a tablespace yesterday, but I can restore from a backup the
> datafile that is in the tablespace, so I'd like to know if there is a mode
> to include that old datafile again in the db without repplying all the log,
> or reimport the data.
> The tablespace contains data for a single user, so no data are lost around,
> all is included in that file.
You can't restore single datafile by attaching it to database. It
doesn't matter if you have any data around. In fact you have always
some data around, even if it is a single tablespace for single user.
However, you're not lost. If you have proper backup, you can easily
recover database to the time before dropping and then just transfer
data between your database and restored one using DB link, exp/imp, as
you wish.
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Wed Jan 15 2003 - 10:50:12 CST
