Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

set AUDIT_FILE_DEST

GKJoeOct 9 2006 — edited Oct 12 2006
while trying to implement auditing with OS option i am gettig the following error.

SQL> alter system set audit_trail=OS scope=spfile;

System altered.

SQL> alter system set AUDIT_FILE_DEST = 'c:\oracle\product' scope=spfile
2 ;
alter system set AUDIT_FILE_DEST = 'c:\oracle\product' scope=spfile
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM

DB version is is 10.1.0.2.0

Is there anything wrong with the syntax?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2006
Added on Oct 9 2006
4 comments
1,034 views