So fundamentally, i don't know Oracle tools very well, and the documentation i've discovered hasn't been intuitive.
My problem is:
i have a running Paid Oracle Apex instance running on OCI (on shared exadata). OCI automatically creates backups. Now its super easy to restore that backup on the same instance, or CLONE another Apex Instance.
BUT, the clone is unfortunately another PAID Apex instance.
I would like to somehow restore/clone the Apex DB to an ALWAYS-FREE instance so that I can do some testing.
Question:
Can someone give me some step by step instructions on how to restore an Apex DB into an *empty* Apex "always free" instance? So that my entire Apex app and all the DB tables appear there?
Please know that I tried the "Apex Export Application" route. Trouble is there is some issue with how Apex application IMPORT works.. It refuses to cleanly process tables with large CLOBS and XML. There's a lot of truncation that happens at the end.