Re: scope
From: Ingrid Voigt <GiantPanda_at_gmx.net>
Date: Wed, 21 Sep 2011 20:27:54 +0200
Message-ID: <4E7A2CAA.3060106_at_gmx.net>
On 21.09.2011 20:12, Zelli, Brian wrote:
> I have to issue this command for some auditing:
> alter system set audit_trail� scope=spfile;
>
> My question is that I still use a pfile. So do I use both or memory or nothing for scope?
Date: Wed, 21 Sep 2011 20:27:54 +0200
Message-ID: <4E7A2CAA.3060106_at_gmx.net>
On 21.09.2011 20:12, Zelli, Brian wrote:
> I have to issue this command for some auditing:
> alter system set audit_trail� scope=spfile;
>
> My question is that I still use a pfile. So do I use both or memory or nothing for scope?
Doesn't work that way. audit_trail is a static parameter and can only be
changed by
bouncing the database. You need to textedit the pfile.
For dynamic parameters you would use memory or leave the scope part out, but without writing the pfile the change is gone when the instance is restarted.
Best regards
Ingrid
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 21 2011 - 13:27:54 CDT