Re: Where is init.ora?
From: Tim Cuthbertson <timNOcuthSPAM_at_bellsouth.net>
Date: Thu, 20 Feb 2003 20:43:32 -0600
Message-ID: <ofg5a.3347$Lz2.193_at_fe04.atl2.webusenet.com>
Date: Thu, 20 Feb 2003 20:43:32 -0600
Message-ID: <ofg5a.3347$Lz2.193_at_fe04.atl2.webusenet.com>
It is normally in $ORACLE_HOME/dbs. But, it is often kept in $ORACLE_BASE/admin/<sidname>/pfile.
When it is kept in the pfile location, there is a link to it in the dbs location.
Tim
"David M Higgs" <david.higgs_at_aldasys.demon.co.uk> wrote in message
news:d1e250c4.0302200850.1c0f2568_at_posting.google.com...
> Dear All
>
> I was given an export routine (thanks Rauf) that uses
> UTL_FILE.PUT_LINE to export my data to files of 50,000 records.
>
> I need to add the line
> utl_file_dir=<my directory>
> to the init.ora file - but where is this file located?
>
> May seem a daft question - new to Oracle!
>
> Running Oracle 8i on Solaris Unix
>
> --
> Regards,
> David
Received on Fri Feb 21 2003 - 03:43:32 CET