3 Replies Latest reply on Nov 9, 2018 5:36 AM by Naveen B

    Oracle extract Failing on Desktop (Manual refresh )

    Sowmya Potluri

      Hello guys,


      one of my Custom SQL Query is failing on server setup due to time limit (120 min) , so i started refreshing manually on desktop, it took more than 400+ min and it failed throwing error some oracle error5125~ small size ......

      ( i didn't capture exact error), i will update error soon.


      can some one suggest the most prominent way to refresh , i tried all refresh available on extract field, (incremental, full, )


      scenario: its weekly refresh, every week business want to see week data, in PDF format .................... query accumulated almost 5 months data ( i guess data piled up is one of the issue to getting refresh(huge data))


      can i use live for these type scenario ?