Do you know this: You just wanted to try something out and after a couple hours playing around with APEX you already have a pretty good application.
Problem is, you experimented on a demo-workspace or on apex.oracle.com and now want to move everything to your own personal development workspace.
And now there are you, hassling around with DDL exports, trying to get your testdata and merge it all together in one install script.
This is a one-click-export Tool. All you need to do is install this small APEX Application in your workspace, run it and press the “Export” button.
You’ll end up with a single Export-File containing all of your datamodel, all data and your APEX application.
Then you take this script and execute it in your target schema/workspace. It’ll create all tables, views, whatever, fill in your data and install the APEX application(s).
Important: This Tool is targeted to the smaller applications. If you try it on a big workspace containing lots of tables, lots of data and multiple applications, the export may get too big and break.
But it’s ideal to move your workspace from http://apex.oracle.com to your local development instance.