undo retention value
Hi All,
I am getting following ORA-01555 error for following sql
ORA-01555 caused by SQL statement below (SQL ID: 9hwwvxc0aa70n, Query Duration=3787 sec, SCN: 0x0001.a84d4a15):
Tue Mar 17 11:38:28 2009
SELECT MSI.SEGMENT1 PART_NUMBER ,REPLACE(MSI.DESCRIPTION,',','.') DESCRIPTION ,MSI.PRIMARY_UOM_CODE UOM ,MSI.UNIT_LENGTH LENG
TH ,MSI.UNIT_WIDTH WEIDTH ,MSI.UNIT_HEIGHT HEIGHT ,MSI.UNIT_VOLUME VOLUME ,MSI.UNIT_WEIGHT NETWEIGHT ,MSI.ATTRIBUTE14 PRICE_C
LASS ,MSI.INVENTORY_ITEM_STATUS_CODE ITEM_STATUS ,( SELECT MSI1.SEGMENT1 FROM MTL_RELATED_ITEMS MRI ,MTL_SYSTEM_ITEMS MSI1 WH
ERE 1=1 AND MRI.RELATIONSHIP_TYPE_ID =2 AND MRI.RELATED_ITEM_ID=MSI1.INVENTORY_ITEM_ID AND MRI.ORGANIZATION_ID=MSI1.ORGANIZAT
ION_ID AND MRI.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID AND MRI.ORGANIZATION_ID=MSI.ORGANIZATION_ID AND ROWNUM=1 ) SUBSTITUTE_
PNO ,MSI.ATTRIBUTE8 REGISTRATION_DATE ,XXJPM.FOB FOB ,( SELECT QLL.OPERAND FROM QP_LIST_HEADERS QLH ,QP_LIST_LINES QLL ,QP_PR
ICING_ATTRIBUTES QPA WHERE 1=1 AND QLH.NAME='EKK PARTS RETAIL PRICE LIST' AND QLH.LIST_HEADER_ID=QLL.LIST_HEADER_ID AND QLL.L
IST_LINE_ID=QPA.LIST_LINE_ID AND NVL(QLL.PRODUCT_UOM_CODE,'Ea')='Ea' AND NVL(QLL.CONTEXT,'SPARES')='SPARES' AND QLH.LIST_HEAD
ER_ID=QPA.LIST_HEADER_ID
The Query Duration=3787 sec.
My undo retention value is 6000 and my undo tablespace have enough space.
Still I am getting this error,
Can someone help me on this.
Thanks