Hi,
I have a dev environment with an 18c Oracle database with APEX full development environment installed, they developed workspaces etc on it. Later I had a qa and a prod environment set up, which had APEX run time environment installed. All of them had ords standalone set up. When setting up qa/prod of course I exported components (mainly workspaces and RESTful services) from dev and imported into qa/prod.
And all of them are good and up and running.
Now they want to "refresh" database from prod to qa/dev. I know for the main schema I will just need to export from prod and import into dev/qa with expdp and impdp, which is simple and reasonable.
My question is toward the APEX part --- what am I supposed to do with the APEX components for this "refreshing" exercise? Do I need to export/import any workspaces from prod to dev/qa? Or should I just leave them as they are on dev/qa? What is the main difference between doing that vs not doing that?
Hope someone can help me out. Thanks!
EZ