2 Replies Latest reply on Jun 13, 2013 10:44 PM by dvohra21

    Tool used to export and import high volume data from Oracle

      We are using certain reports (developed in XLS and CSV) to extract more than 500K to 1M records in single report. There around 1000 reports generated daily. The business users review those reports and apply certain rules to identify exceptions then they apply those corrections back to the system through XL upload.

      The XL reports are developed in TIBCO BW and deployed in AMX platform. The user interface is running on TIBCO GI.
      Database Version: Oracle (RAC - 2 node)

      The inputs around following points will be of great help:
      1) Recommendation to handle such higher volumes reports and mechanism to apply bulk correction back to system?
      2) Suggestions for any Oracle tool or third party tool

      Edited by: meet_sanc on 1 Jun, 2013 4:36 AM

      Edited by: meet_sanc on 1 Jun, 2013 8:20 AM