What are the scenarios for updating a relational database schema without disabling users?

Question

Oracle

Actually the question is: how can you organize the installation of updates to the database without the need to disable users. What are the technical possibilities for this, for example in Oracle?

Answer 1

Absolutely no downtime. You can use Golden Gate (replication), but it's pretty adventurous. More details here:
www.oracle.com/technetwork/middleware/goldengate/o...