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: create controlfile (help needed)

Re: create controlfile (help needed)

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 22 Feb 2003 13:29:15 GMT
Message-ID: <Xns932A37D2B3077SunnySD@68.6.19.6>


"Andy Kwok" <andy.kwok_at_noos.fr> wrote in news:3e575787$0$1565$79c14f64_at_nan-newsreader-01.noos.net:

> Hello
>
> I'm facing a kind of huge problem .
>
> I'm trying to make a copy of my database (on SunOs 2.6 with oracle
> 7.3.4) ) but with mssing datafile .
>
> I've the essential datafile (for the tablespace system, the tablespace
> for the rollback and last but not least the temporary tablespace ) and
> of course the redo log files .
>
> But some of my datafile are missing .
>
> Do you know if it is possible to recreate control files ?

Yes, it is possible using vi or any other text editor. After entering the necessary SQL in the file, use this file to have Oracle create the control files. Received on Sat Feb 22 2003 - 07:29:15 CST

Original text of this message

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