Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Refreshing UAT Instance from Production in Oracle APEX Cloud (ATP Cloud)

OraFusionworldMar 20 2025 — edited Mar 21 2025

We are using Oracle APEX Cloud on top of ATP Cloud and would like to refresh our UAT instance from the Production instance.

Could you please advise on the step-by-step process for this refresh? Additionally, if there is any official documentation covering this, please provide references.

Thank you!

jariola

Even you use APEX, this is more database question.

I assume you use autonomous database (APEX or ATP workload) in Oracle cloud.

You can clone your production database to new database and then terminate your old UAT, when you don't need it anymore. Move any changes that that wasn't in production to new UAT database using e.g. methods you normally make changes. Note, because clone is creating new database, e.g. ORDS URL will not be the same as in your old UAT.

https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/clone-autonomous-database.html

If you use APEX workload your other options are more limited, because there isn't SQL net connection.

Another option might be use dbms_datapump to export/import your application schemas.

1 person found this helpful

jariola

Since the question is not related to APEX, I have moved it to the Oracle Database Discussions category.

OraFusionworld

Thank you @jariola for your help on this!

We are using a couple of DB schemas only for APEX in Oracle ATP Cloud. For other schemas, there are dependencies, and we are unable to clone entire db.

jariola

I think then you should look dbms_datapump, if you are using ADB-S APEX workload. These links might also help

https://cloud.jaris.fi/ords/r/jaris/blog/post?p2_post_id=20230325083035133857

http://dgielis.blogspot.com/2021/01/import-existing-database-and-apex-app.html

https://oracle-base.com/articles/misc/data-pump-api

If you use ADB-S ATP, then it might be easier use e.g. SQLcl or expdp and impdp.

https://docs.oracle.com/en/database/oracle/sql-developer-command-line/24.4/sqcug/using-data-pump.html#GUID-60A99040-20F7-42A1-9544-DEAC0B211C85

1 - 4