Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: datafile problem on 8.0.4 (windows NT)

Re: datafile problem on 8.0.4 (windows NT)

From: Mario Bucsics <mario.bucsicsNOmaSPAM_at_siemens.at.invalid>
Date: Fri, 10 Dec 1999 06:49:12 -0800
Message-ID: <08335b66.7be07d2d@usw-ex0101-003.remarq.com>


Hi

Itīs no problem. Just set the datafile offline immediate:

alter database datafile 'filename' offline immediate;

after that you can open your database normal. If your database is in archivelog restore the datafile and recover it.

now you can set the datafile online again.

 Bye

 Mario

Received on Fri Dec 10 1999 - 08:49:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US