环境:
oracle RAC 2节点
DG 单节点
问题:
在DG上执行sqlserver到oracle的linkserver的ETL查询报错:
oracle RAC 2节点
DG 单节点
问题:
在DG上执行sqlserver到oracle的linkserver的ETL查询报错:
Package Name: WMSINFO_ETL_StockPackage_5th Start Time: 2017/11/14 16:53:55
Error: WMS_STOCK源 无法处理这些数据。ORA-01555: 快照过旧: 回退段号 39 (名称为 "_SYSSMU39_3029844184$") 过小
DG上DB的alert日志:
ORA-01555 caused by SQL statement below (SQL ID: gyjxsr15qwqqy, Query Duration=1834 sec, SCN: 0x0001.68c59971):
select a.WHSEID, 'HBRDC' as WMS_RDCCode,a.StorerKey, b.Lottable03, c.Description , b.Lottable08, a.Loc, d.SKUGroup2 MaterialCode, d.SKUGroup SizeName, a.SKU, d.BUSR2, d.BUSR3, d.busr9, d.busr10, SUSR4, sum(nvl(a.Qty, 0)) Qty from WMWHSE1.Lotxlocxid a inner j