Oracle Cloud Infrastructure Documentation

Change the schema of a Global Active table

You should avoid changing the schema of a Global Active table as any changes to the schema involve re-synchronizing data to all replicas.

You can instead leverage the flexibility available with the JSON column to bring about the schema changes. If you are not able to avoid a schema change to a Global Active table, follow the steps outlined below:
  1. Drop the replicas of the table whose schema has to be changed.
  2. In the table details, click Unfreeze to change the schema of the singleton table back to Mutable.
  3. Change the schema of the table.
  4. In the table details, click Freeze to freeze the schema of the table. The Schema state changes to Frozen.
  5. Re-create the regional table replicas.