Home » RDBMS Server » Server Administration » Help! Oracle 8i Create SPFILE error
Help! Oracle 8i Create SPFILE error [message #64535] Sat, 05 February 2005 05:30 Go to next message
Ren
Messages: 3
Registered: February 2005
Junior Member
Is it possible to create a spfile in Oracle 8i Enterprise 8.1.7.4.1?

I issued the following command and got these results

create spfile from pfile;
Error at Line 1:
ORA-00901: invalid CREATE command

Can anyone help?

Report message to a moderator

Re: Help! Oracle 8i Create SPFILE error [message #64538 is a reply to message #64535] Sun, 06 February 2005 05:43 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it is available from 9i
http://www.orafaq.com/parms/parm1176.htm

and correct syntax would be

sql> create spfile 'spfilename' from pfile='pfilename';

Report message to a moderator

Previous Topic: macfee antivirus effect oracle installation
Next Topic: Archive Destination
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 04:24:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.