oracle报错最大游标数超过限制,需要加大最大游标数。我查了网上的方法,alter system set open_cursor='800', scope=both;使用sys,sysdba登陆,运行上面的sql语句,结果报错ora-02065,system项错误,可是我检查了下,我没有写错啊帮忙想下是哪儿的问题吧。。ORACLE10G
alter system set open_cursorS='800', scope=BOTH; 尝试上面的命令.
open_cursor少了个S吧SQL>show parameter open_cursor NAME TYPE VALUE ------------------------------------ ----------- ------ open_cursors integer 300 SQL>alter system set open_cursors='800' scope=both
alter system set open_cursors='800', scope=both;
alter system set open_cursors='800' scope=both
alter system set open_cursors='800', scope=both;
SQL> show parameter open_cursorNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ open_cursors integer 300SQL> alter system set open_cursors=800 scope=both;系统已更改。SQL> show parameter open_cursorNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ open_cursors integer 800 SQL>
用SYS 帐号,DBA权限登陆后 执行就好了 alter system set open_cursors='800', scope=both;
alter system set open_cursors='800', scope=both; 学习了
你要了个S alter system set open_cursors='800', scope=both;
网上摘抄........ declare cursor c1 is select psn_seg_segment_no, psn_id, psn_name, department, reason, stype, begintime, endtime, hourt, cday, re, if_type, check_flag, rowid row_id from hr_overtime_if where check_flag = 'Y' --表示需要被导入 for update; --表明被检索出的数据被lock,只有当前user可以操作,其它user必须等待begin for cc in c1 loop if psn_id is null then update hr_overtime_if set error_code = '工号错误,请更正!', check_flag = 'N' where current of c1; -- end if; end loop;end;
NAME TYPE VALUE
------------------------------------ ----------- ------
open_cursors integer 300
SQL>alter system set open_cursors='800' scope=both
------------------------------------ ----------- ------------------------------
open_cursors integer 300SQL> alter system set open_cursors=800 scope=both;系统已更改。SQL> show parameter open_cursorNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 800
SQL>
alter system set open_cursors='800', scope=both;
学习了
alter system set open_cursors='800', scope=both;
declare
cursor c1 is
select psn_seg_segment_no,
psn_id,
psn_name,
department,
reason,
stype,
begintime,
endtime,
hourt,
cday,
re,
if_type,
check_flag,
rowid row_id
from hr_overtime_if
where check_flag = 'Y' --表示需要被导入
for update; --表明被检索出的数据被lock,只有当前user可以操作,其它user必须等待begin
for cc in c1 loop
if psn_id is null then
update hr_overtime_if
set error_code = '工号错误,请更正!',
check_flag = 'N'
where current of c1; --
end if;
end loop;end;