I need to apply the changes on the DB (add new table and modify some...), I am looking to make the Database in a "READ ONLY" mode, so that users can not add or edit anything on DB, during the time I am working on production -- the reason is that we have a NOC operation that need to have a non-stop service /access to DB.
When I alter DATABASE to READ ONLY, I see that I cannot even access the APEX app...
Any help will be appreciated.
This is not possible, because just accessing APEX makes APEX write allot of stuff to the database, like session information for example. In a read only database this is not possible.
The only workaround is creating a 2nd non-readonly database where you store just your APEX application, and where you use database links for all your tables/packages/views/etc to your read only database.