Hi Experts,
The following query is failing with snapshot too old error.
ORA-01555: snapshot too old: rollback segment number 182 with name "_SYSSMU182_154367982$" too small.
The query is fetching 5311894582 records.
We are erunning queries in upstream database. We dont have any control on the database.
Please help me how to avoid this error by using some hints (or) any other changes in the query.
SELECT
CUST_NUM
||''||CUST_ID
||''||''||REPLACE(REPLACE(APPLICATION_ID,chr(10),chr(05)),chr(13),chr(06))||''
||''||''||REPLACE(REPLACE(DL_SERVICE_CODE,chr(10),chr(05)),chr(13),chr(06))||''
||''||CUST_NAME
||''||''||REPLACE(REPLACE(CUST_TYPE,chr(10),chr(05)),chr(13),chr(06))||''
||''||''||REPLACE(REPLACE(CUST_SUB,chr(10),chr(05)),chr(13),chr(06))||''
||''||''||REPLACE(REPLACE(CUST_COMP_TXT,chr(10),chr(05)),chr(13),chr(06))||''
||''||''||REPLACE(REPLACE(CUST_OLD_TXT,chr(10),chr(05)),chr(13),chr(06))||''
||''||''||REPLACE(REPLACE(CUST_INM,chr(10),chr(05)),chr(13),chr(06))||''
||''||CONV_RUN_NO
||''||CUST_AMT
||''||''||REPLACE(REPLACE(CUST_PROD_TP,chr(10),chr(05)),chr(13),chr(06))||''
||''||''||REPLACE(REPLACE(CUST_AID,chr(10),chr(05)),chr(13),chr(06))||''
||''||''||REPLACE(REPLACE(INT_ID,chr(10),chr(05)),chr(13),chr(06))||''
||''||''||REPLACE(REPLACE(TR_IND,chr(10),chr(05)),chr(13),chr(06))||''
FROM cust_master
WHERE update_date_time > TO_TIMESTAMP('2002-10-05 12:14:44.0', 'YYYY-MM-DD HH24:MI:SS.FF')
Please help me .
Thanks in advance.