在本机尝试了下
SQL> create table d(deptno number primary key);
表已创建。
SQL> create table e(empno number primary key,deptno number references d(deptno));
表已创建。
insert into d values (01);
insert into d values (02);
insert into d values (03);
insert into d values (04);
insert into e values(1001,01);
insert into e values(1002,02);
insert into e values(1003,03);
delete d where deptno=04; 没有commit
SQL>select * from v$locked_object
XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME
OS_USER_NAME
---------- ---------- ---------- ---------- ---------- ------------------------------ ---------
-----
PROCESS LOCKED_MODE
------------ -----------
7 32 589 51789 159 YDC
1BEC1F04CDC94D4yudingchu
2748:3140 3
7 32 589 51787 159 YDC
1BEC1F04CDC94D4yudingchu
2748:3140 3
create table e(empno number primary key,deptno number references d(deptno) on delete cascade;
SQL> select * from v$locked_object;
XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME
OS_USER_NAME
---------- ---------- ---------- ---------- ---------- ------------------------------ ---------
-----
PROCESS LOCKED_MODE
------------ -----------
3 27 580 51793 159 YDC
1BEC1F04CDC94D4yudingchu
2748:3140 3
3 27 580 51791 159 YDC
1BEC1F04CDC94D4yudingchu
2748:3140 3
有什么问题。请指教