APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to export data via DBLink in APEX 24.1?

Marcelo Martins Spegiorin Filho9 hours ago

I am using Oracle APEX 24.1 running on-premises with an Oracle Database 19c.

I have already built an APEX application that allows me to dynamically export DDL scripts from my database (by selecting which objects I want to include). This works fine even across databases using a DBLink.

Now, I would like to extend this logic to also export the data (data dump) through a DBLink.

Has anyone implemented a similar approach or could suggest the best way to achieve this in APEX? Ideally, I would like to keep the same pattern I used for the DDL export, but for data.