Pages

Thursday, September 26, 2019

Read Only Table/Session/DB




Table
* make RO: ALTER TABLE table1 READ ONLY;

* check RO : select read_only from user_tables where table_name = 'XXX'

DBmake RO alter database open read only;

* check RO : select open_mode from v$database;

Session * make RO:  * set transaction read only;