Re: How to restore an old Tablespace/Datafile?

From: Meinolf Klement <Meinolf.Klement_at_t-online.de>
Date: 17 Sep 1998 14:32:15 GMT
Message-ID: <6tr6hf$g76$1@news01.btx.dtag.de>

There is one workaround (I really cannot recommend this to productive databases and to be done by newbies; I really don't recommend this at all!)

Create an empty tablespace/datafile at the same place with the same parameters. You then might want to have a look at the first <db-block-size> bytes of the old datafile and compare it to the new one. Then (database offline and backed up) replace the new datafile with the old one and modify the header-block according to the changes you have found.
It's very tricky and you have to understand what's in the datafile.

Regards
Meinolf

On 20 Jul 1998 17:12:00 GMT, "Luca Minudel" <luca.minudel_at_nline.it> wrote:

>I need to restore an old Tablespace made of 1 datafile replacing the =
>actual Tablespace.
>I've Db with NOARCHIVELOG setting.
>How can I do this?
>
>TIA
>
>--=20
>___________________________________________________
> Luca Minudel software designer
> Italy Conegliano (TV)
> voice & fax +39 (0)438 412280
> e-mail luca.minudel_at_nline.it
> WWW (italian language used)
> http://www.geocities.com/SiliconValley/Vista/4041
>
Received on Thu Sep 17 1998 - 09:32:15 CDT