Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create controlfile (help needed)
"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