Re: Control File - Oracle 8.0.5. under WinNT

From: <aausb_at_my-deja.com>
Date: Fri, 24 Dec 1999 08:17:11 GMT
Message-ID: <83va2o$qu1$1@nnrp1.deja.com>

In article <sJz84.11735$fy1.928_at_tundra.ops.attcanada.net>, "OraFan" <your_at_attcanada.net> wrote:
> Hi
>
> I need to create a control file for a database copies of which somehow
been
> lost or whatever. I could not find much help on this, so will
appreciate if
> someone can help me create that -
>
> Tks so much
> Farj
>
>

Hi Farj,

with "alter system backup controlfile to trace" you make a copy of controlfile to bdump. You can edit this SQL-file, change SID " SET DATABASE SID" and change locations of datafiles and so on.

Andreas

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 24 1999 - 02:17:11 CST