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!

alter system with scope=both

96429May 29 2003 — edited Feb 15 2005

Hi,

I am trying to enable automatic log archiving at instance start up. I have tried to use the "scope=both" parameter to change both the current session and have it also update the spfile. I tried using this command:

alter system archive log start to 'C:\oracle\ora92\database\dbname\archive' SCOPE=spfile;

However it give me an error at the keyword SCOPE saying:

ERROR at line 1:
ORA-00933: SQL command not properly ended

Any ideas on how to do this or do I have to export the spfile to a pfile, make the changes there and then create the pfile from the spfile ?

Thanks in advance,

Ned

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2005

Added on May 29 2003

#general-database-discussions

11 comments

11,041 views