Re: How do you take an OMF offline?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 5 May 2003 22:37:38 +1000
Message-ID: <kIsta.29205$1s1.430121@newsfeeds.bigpond.com>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:g2q9bvc7c0937tf7tsreueg3ksn1814nsc_at_4ax.com...
> How do you take an OMF offline? Every time I tried to do so, I got an
> error message. I assume you cannot really do this since Oracle is
> managing all the files.
>

Hi Peter,

No, OMF files can be manipulated like any other data file:

SQL> alter database datafile 'C:\BOWIE\O1_MF_OMF_TS_ZCDP5S00_.DBF' offline;

Database altered.

How else are you expected to recover it (for example) ...

What error message are you experiencing ?

Regards

Richard Received on Mon May 05 2003 - 07:37:38 CDT