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 set control files

415008May 10 2004 — edited Feb 15 2005

I'm using oracle 9i .I tried to multiplex one of the control file so i did the following :
conn sys/change_on_install as sysdba
alter system set control files ='c:\oracle\oradata\oracle9i\control01.ctl' scope=spfile;

But i received the follwoing error once i ran it:

Error at line 1:
ora-02065 :illegal for alter system

I wonder why this error raised , How i can solve it .
the oracle home is under drive d.

Any help would be appreciated

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2005

Added on May 10 2004

#general-database-discussions

7 comments

6,328 views