This discussion is archived
2 Replies Latest reply: Jun 13, 2013 3:44 PM by dvohra21 RSS

Tool used to export and import high volume data from Oracle

922306 Newbie
Currently Being Moderated
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 11.2.0.3.0 (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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points