INSERT takes forever
Hi,
version: 11.2.0.2
The following has been running for many hours in our DEV environment:
INSERT INTO ldw.mft_satx_itm (DAY_TIME_KEY,
SKU_PROD_KEY,
STOR_LOC_KEY,
TOD_HOUR_KEY,
TX_TYPE_KEY,
CUID_CUST_KEY,
PRCE_KEY,
EMPL_CSHR_KEY,
SALE_PRCE_TYPE_KEY,
TX_SEQ_NO,
ITM_SEQ_NO,
TX_REV_NO,
LINE_NO,
VCHR_NO,
REG_NO,
TX_NO,
VLD_TX_CNT,
VCHR_CNT,
RTL_QTY,
RTL_VAT_AMT,
DISC_QTY,
DISC_VAT_AMT,
IN_PRCE,
COST_AMT,
PRCE_LST_VAT_AMT,
VAT_RATE,
ADD_VAT_FCTR,
RMV_VAT_FCTR,
CLR_FLAG,
LOAD_TSTM)
SELECT DAY_TIME_KEY,
version: 11.2.0.2
The following has been running for many hours in our DEV environment:
INSERT INTO ldw.mft_satx_itm (DAY_TIME_KEY,
SKU_PROD_KEY,
STOR_LOC_KEY,
TOD_HOUR_KEY,
TX_TYPE_KEY,
CUID_CUST_KEY,
PRCE_KEY,
EMPL_CSHR_KEY,
SALE_PRCE_TYPE_KEY,
TX_SEQ_NO,
ITM_SEQ_NO,
TX_REV_NO,
LINE_NO,
VCHR_NO,
REG_NO,
TX_NO,
VLD_TX_CNT,
VCHR_CNT,
RTL_QTY,
RTL_VAT_AMT,
DISC_QTY,
DISC_VAT_AMT,
IN_PRCE,
COST_AMT,
PRCE_LST_VAT_AMT,
VAT_RATE,
ADD_VAT_FCTR,
RMV_VAT_FCTR,
CLR_FLAG,
LOAD_TSTM)
SELECT DAY_TIME_KEY,
0