CREATE OR REPLACE procedure sunq_bonus_insert
(p_name_in in varchar2,p_job_in in varchar2)
as
begin
update bonus set job=p_job_in where ename=p_name_in;
end;
/The following error has occurred:ORA-03212: 无法在本地管理的表空间创建临时段
(p_name_in in varchar2,p_job_in in varchar2)
as
begin
update bonus set job=p_job_in where ename=p_name_in;
end;
/The following error has occurred:ORA-03212: 无法在本地管理的表空间创建临时段
Cause: An attempt was made to create a temporary segment for
SORT/HASH/LOBS in a locally-managed permanent tablespace.Action: Alter temporary tablespace of user to a temporary tablespace or a
dictionary-managed permanent tablespace.
改變你的 bonus 表所在的表空間,的執行:
alter tablespace your_tablespace temporary;
SQL> CREATE OR REPLACE procedure sunq_bonus_insert
2 (p_name_in in varchar2,p_job_in in varchar2)
3 as
4 begin
5 update bonus set job=p_job_in where ename=p_name_in;
6 end;
7 /过程已创建。
SQL> exec sunq_bonus_insert('eof','aaaa');PL/SQL 过程已成功完成。SQL> commit;提交完成。请教各位高手了!