Re: Oracle database move to a new machine

From: Hans Forbrich <forbrich_at_tyahoo.net>
Date: Sat, 29 Nov 2003 06:40:43 GMT
Message-ID: <3FC83F5E.C76C6D43@tyahoo.net>

v5034 wrote:
>
> I am very familiar with the initSIDXXX.ora but what is the
> spfileSIDXXXX.ora file?
>
> Thanks
>

The replacement in the new world. Always stored on the server. Allows changing [most] parms 'remotely'.

Don't edit it! It's a 'binary' file & edits can easily made the database unusable.

Read the documentation - new features guide, upgrade docco, concepts manual, DBA guide. All refer to it and help build a complete picture of the reasons, advantages (and disadvantages, according to some). Too much to list in a short NG missive.

If you really want to dba in 9i and up, learn this! Received on Sat Nov 29 2003 - 00:40:43 CST