Hello dear experts,
I am working for a customer, that exports data to later import them into their SAP environment. The export is quite complex and even uses the APEX-tables. The export is done by several queries, that construe a new query, that is eventually used to do the export of the data and saves it into a file. The export and the creation of the file are fine and they also work performantly.
The project leader has signalised a performance problem during the import of the file. Apparantly SAP has a problem with the import of lots of records. The project leader has suggested to implement some kind of counter to reduce the file size. When the export would have been done using PL/SQL, that might be one solution, but it is not. I do not want to touch the concept behind the export using SQL, because of the complexity of the matter.
What I would like to ask you is: is there a way of splitting up the file into several smaller files using PL/SQL? If yes, how?
Thank you very much for your help!
Hannu