Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.nuthinbutnews.com!propagator2-sterling!news-in.nuthinbutnews.com!ken-transit.news.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail From: "Richard Foote" Newsgroups: comp.databases.oracle.server References: Subject: Re: How do you take an OMF offline? Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Mon, 5 May 2003 22:37:38 +1000 NNTP-Posting-Host: 203.54.191.122 X-Trace: newsfeeds.bigpond.com 1052137360 203.54.191.122 (Mon, 05 May 2003 22:22:40 EST) NNTP-Posting-Date: Mon, 05 May 2003 22:22:40 EST Organization: Telstra BigPond Internet Services (http://www.bigpond.com) Xref: core-easynews comp.databases.oracle.server:185300 X-Received-Date: Mon, 05 May 2003 05:35:40 MST (news.easynews.com) "Peter" wrote in message news:g2q9bvc7c0937tf7tsreueg3ksn1814nsc@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