Question

oracle ALTER SYSTEM SET CONTROL FILES='D:\files\oradata\orcl\CONTROL01.CTL'出错

SQL> ALTER SYSTEM SET CONTROL FILES='D:\files\oradata\orcl\CONTROL01.CTL',
2 'D:\files\oradata\orcl\CONTROL02.CTL','D:\files\oradata\orcl\CONTROL03.CTL' SCOPE=SPFILE;
ALTER SYSTEM SET CONTROL FILES='D:\files\oradata\orcl\CONTROL01.CTL',
*
第 1 行出现错误:
ORA-02065: 非法的 ALTER SYSTEM 选项

Answer 1

control_files control和files中间加上_
alter system set control_files='D:\files\oradata\orcl\CONTROL01.CTL',
'D:\files\oradata\orcl\CONTROL02.CTL','D:\files\oradata\orcl\CONTROL03.CTL' SCOPE=SPFILE;

Answer 2

controlfiles应该连起来写吧。