Home » RDBMS Server » Server Administration » Delete default Oracle Parameter
Delete default Oracle Parameter [message #272489] Fri, 05 October 2007 04:36 Go to next message
atul1910
Messages: 1
Registered: October 2007
Location: India
Junior Member
Hello Oracle Gurus,

Can anyone tell me how an Oracle parameter can be deleted. For e.g there is a oracle parameter CPU_COUNT in our oracle database with the default value. It is niether in the pfile nor the spfile. This parameter has become obsolete as of Oracle 9i and should be deleted. How can it be deleted? Can anyone tell me the command please?

Regards,
Atul Lotlikar.

Report message to a moderator

Re: Delete default Oracle Parameter [message #272493 is a reply to message #272489] Fri, 05 October 2007 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not obsolete and exists in all versions.
You MUST NOT set it, let it to its default value.
Remove it for your configuration file if it is there.

Regards
Michel

Report message to a moderator

Re: Delete default Oracle Parameter [message #272524 is a reply to message #272489] Fri, 05 October 2007 07:15 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
This does not make sense. How can you delete it if you never set it?
Why bother if it is obsolete?

[edit: ok, if it were obsolete; apparently it is not]

[Updated on: Fri, 05 October 2007 07:16]

Report message to a moderator

Previous Topic: Identifying Unused Schema/Tables
Next Topic: Oracle Universal Installer not launching on Windows Server 2003
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 10:50:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.