ALTER TABLE crms.t_crm_customer
Modify(
customerchinesename NVARCHAR2(50)
);
该语句的作用是将customerchinesename 列的长度改为 NVARCHAR2(50)执行时报资源正忙,要求指定nowait
Modify(
customerchinesename NVARCHAR2(50)
);
该语句的作用是将customerchinesename 列的长度改为 NVARCHAR2(50)执行时报资源正忙,要求指定nowait
select a.sid,a.serial#,a.username,a.program,
c.owner, c.object_name ,a.MACHINE,a.TERMINAL
from v$session a, v$locked_object b, all_objects c
where a.sid=b.session_id and
c.object_id = b.object_id
用这个脚本可看锁住的对象
杀掉这个进程。