Home » RDBMS Server » Server Administration » spfile & pfile
spfile & pfile [message #8739] Tue, 23 September 2003 00:36 Go to next message
Cindreen Clarence
Messages: 41
Registered: March 2003
Location: Bangalore
Member
what is spfile
& pfile used for?

Report message to a moderator

Re: spfile & pfile [message #8740 is a reply to message #8739] Tue, 23 September 2003 01:07 Go to previous message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Pfile is the Parameter which poibnted to the init<SID>.ora. Oracle needs this file pointer to start and operate.
SPFILE is the new version of pfile and means "Server Parameterfile". This file is the Pfile translated in machine code. Oracle 9 uses this way to make sure that nobody can change parameters without translating them into DB. But you can set Oracle 9i to use PFile again.
rgds
Uwe

Report message to a moderator

Previous Topic: Oracle 9.2.0 -Archive log error even after multiplexing !!!
Next Topic: whats wrong in this
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:43:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.