SQL> alter system set log_archive_dest_1='/u02/archive_log/' scope=both;
alter system set log_archive_dest_1='/u02/archive_log/' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE
在设置log_archive_dest_1的值时,引号中有‘location=’关键字,如下
SQL> alter system set log_archive_dest_1='location=/u02/archive_log/' scope=both;
System altered
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-1418474/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-1418474/