我试了一下没问题,我建了一下这样的脚本,取名为itpub1.sql
ALTER SYSTEM SET CONTROL_FILES=
'/home/jj1/ct01.ctl',
'/home/jj1/ct02.ctl',
'/home/jj1/ct03.ctl',
'/home/jj1/ct04.ctl' SCOPE=SPFILE;
/
执行结果如下:
SQL> @/home/jj1/itpub1.sql
System altered.
System altered.
仔细看看你的图片,
1ALTER SYSTEM SET CONTROL_FILES=
2'H:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL',
3'H:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL03.CTL',
4'H:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL',
5'I:\Oracle back up\CONTROL04.CTL' SCOPE=SPFILE;
SQL> /
Alter system是命令的开始,为什么在它之前会有个“1”的行号呢。正常的应该是这样的:
SQL> ALTER SYSTEM SET CONTROL_FILES=
2'/home/jj1/ct01.ctl',
3'/home/jj1/ct02.ctl',
4'/home/jj1/ct03.ctl',
5'/home/jj1/ct04.ctl' SCOPE=SPFILE;
System altered.
SQL> /
System altered.
第一个;号,语句成功执行,再到/,语句又被执行了一次,这很正常。
|