Re: Un set parameter in spfile

On Mon, 16 Aug 2004 08:31:17 +1000, Howard J. Rogers wrote:

> Because not all parameters can be modified dynamically with an
> unqualified 'alter system' command. The SID clause is compulsory, by the
> way, even in a single instance environment.

Yes it is, but if you don't know the sid, you can specify '*' for sid. Usuually, if the sid is not specified in 'ALTER SYSTEM SET PARAM=VAL SCOPE=SPFILE' command, the parameter is written down as '*.PARAM'. What I don't understand is why did oracle opt for the shell metacharacter '*' instead of the usual relational '%'?

-- 
A city is a large community where people are lonesome together.