Re: Oracle 8.1.6: file location

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 6 Nov 2001 11:07:39 +0100
Message-ID: <tufgjeh32i4g46@corp.supernews.com>

"Stephan van Hoof" <test_at_test.com> wrote in message news:9s89sl$6qa$1_at_news1.xs4all.nl...
> Hi there,
>
> Just wondering where to place my pfile and datafiles on oracle 8.1.6
>
> - pfile:
> in oracle\admin\<SID>\pfile\pfile.ora
> OR
> in \oracle\ora81\database\init<sid>.ora ?
>
> - datafiles:
> in oracle\oradata\<SID>
> OR
> in \oracle\ora81\oradata\<SID> ?
>
> Thanks,
> Stephan
>
>

A default install has
a 'stub' pfile in \oracle\ora81\database\init<sid>.ora pointing to \oracle\admin\<SID>\pfile\init.ora
and datafiles in
\oracle\ora81\oradata\<SID>

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Tue Nov 06 2001 - 04:07:39 CST