OIC Failing Due to XML Size Limit Exceeding 100MB in ATP Data Transfer

We are encountering a critical issue in Oracle Integration Cloud (OIC) while transferring data from a public ATP table to a private ATP database. When executing a SELECT query, the XML payload exceeds the 100MB limit, leading to integration failure with the error message: "XML exceed a maximum size." This prevents data transfer, blocking our development and delaying project timelines. We seek any guidance on the best approach to efficiently handle large data transfers between ATP databases and request recommendations on alternative methods such as streaming, chunking, or direct DB-to-DB transfer to overcome the XML size limitation. Urgent assistance is required to resolve this issue.