11gR2: APPEND on partition and table level lock ?
Hi ,
I have 2 partitioned tables : PRODUCTS and PRODUCTS_2 , partition key = PROD_TYPE
Is it true that the following insert with append hint performed on only one partition locks all the table ?
If Yes , what is the trick to avoid this lock on table level ?
INSERT /*+ APPEND */ INTO PRODUCTS
SELECT ... FROM PRODUCTS_2 P2
WHERE P2.PROD_TYPE='AC'
AND ...
Best regards.
GD.
I have 2 partitioned tables : PRODUCTS and PRODUCTS_2 , partition key = PROD_TYPE
Is it true that the following insert with append hint performed on only one partition locks all the table ?
If Yes , what is the trick to avoid this lock on table level ?
INSERT /*+ APPEND */ INTO PRODUCTS
SELECT ... FROM PRODUCTS_2 P2
WHERE P2.PROD_TYPE='AC'
AND ...
Best regards.
GD.
0