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;


Friday, September 20, 2019


Gibberish Snippets  

* clean up print file for reading: sed 's/\x00//g; s/\x0c/\x0a/g;' PRINT