Hi Everyone, Please i have an issue with my code. im trying to create a table with 20 mill row reading from oracle data base. however i get the below log error proc sql; 374 create table soap_detl1 as 375 select a.ssnbr ,a.indnbr ,a.contnbr ,a.item ,a.qtycl ,a.qtyapp ,a.totcl ,a.totapp ,a.paid_amt ,a.exceedlimd 375 ! ,a.netamt ,a.prov_net_amt ,a.totrcvry 376 ,a.discd ,a.hasitems ,a.covnetamt ,a.treatperiod ,a.penaltyd ,a.reqnum ,a.untprice ,a.QTY_TYPE ,a.discount 376 ! ,a.pa_flg ,a.mnsrv 377 from &OPERATION..soapdetl_up a inner join ssnbr_list b 378 on a.ssnbr=b.ssnbr ; ERROR: Error fetching from cursor. ORACLE error is ORA-01555: snapshot too old: rollback segment number 88 with name "_SYSSMU88_4158259342$" too smallORA-02063: preceding line from STBDBLNK. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 379 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 59:35.10 cpu time 2:26.56 Appreciate your support Thank you, Ahmed Maher
... View more