在TollDB_Aix数据库下有下面一个表
create table GLB_LANESTATUS
(
RECORDTYPE NUMBER(2),
NETWORKCHAR(8) not null,
STATIONCHAR(16) not null,
LANE CHAR(10) not null,
SEGMENTCHAR(6) not null,
TIME CHAR(28) not null,
OPERATORID CHAR(10),
SHIFTNUMBER(1),
LANESTATUS NUMBER(1),
DEVICESTATUS CHAR(48),
TIMEFLAG CHAR(28)
)
tablespace TS_DATA
alter table GLB_LANESTATUS
add constraint PK_GLB_LANESTATUS primary key (NETWORK,STATION,SEGMENT,LANE,TIME)
using index
tablespace INDX
在本地有一个表tbl_rtLaneStatus和上面的表 结构相同
在本地创建了一个数据库连接TollDB_AIX
执行下面的语句会产生表死锁
insert into tbl_rtlanestatus
select * from GLB_LANESTATUS@TollDB_AIX
where
(NETWORK,STATION,LANE ,
SEGMENT ,TIME) in
( select NETWORK,STATION,LANE ,
SEGMENT ,max(TIME) from GLB_LANESTATUS@TollDB_AIX
group by select NETWORK,STATION,LANE ,SEGMENT
)
请各位大侠指点
|