we have a non-production environment and a production environment where there's two identical servers sharing the same Oracle database.
All servers are running the same version (16.00.0000.01202).
As expected, we'd like to perform changes in non-production env. and then copy those changes to the production environment.
Can we copy all the oracle user's objects to the production db directly without down time or you advise against that ?
What would be the best solution.