Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will discuss Making Tablespace Read-Only. In this, we will be learning how to prevent writes to data files in the tablespace.
Writing operations do not occur on a tablespace set to read-only.
By default it is created in READ WRITE mode.
1 2 3 | SQL> ALTER TABLESPACE HR_BIGTS READ ONLY; Tablespace altered. |
The tablespace can be put back into write mode later.
1 2 3 | SQL> ALTER TABLESPACE HR_BIGTS READ WRITE; Tablespace altered. |
