Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: restore with only one datafile ...
Hello,
The problem is the following:
We had a USERS tablespace with a single datafile "users" (in an archive mode
DB), and we have now a hot backup of only this datafile to recover from a
new database; is it possible to move this datafile objects to the new
datafile "users" of the new tablespace USERS? (to retrieve our old users and
objects!)
Thanks,
Regards.
"NorwoodThree" <norwoodthree_at_my-deja.com> a écrit dans le message news:
ba03e2c.0202111622.6a6ce120_at_posting.google.com...
> "Epicentre Team ANNECY" <djeanneret_at_epicentre.fr> wrote in message
news:<a48sgf$mbi$1_at_wanadoo.fr>...
> > Is possible to restore a tablespace if USER datafile is the only file
> > backuped?
> > Of course it's just an exercise for a stage !!
> >
> > Thanks
>
> I dont think I understand the question. Do you mean that your have
> multiple datafiles for the USER tablespace, and 1 of them needs to be
> restored due to corruption? Please clarify; the phrasing of your
> question makes it sound like you aren't familiar with Oracle
> architecture...
Received on Tue Feb 12 2002 - 02:52:35 CST