What is the recommended approach for bulk data loading into Oracle ATP?
Summary:
We have a requirement to extract data using BIP, which is then loaded into an ATP table for downstream use in VBA and APEX applications. Currently, we are inserting each record from the BIP output into the ATP table one row at a time. Is there a more efficient, batch loading option available for this process?
We are utilizing the Oracle ATP adapter for the integration.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):