Making Tablespace Read-Only

Onur ARDAHANLI

8 months ago

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.

SQL> ALTER TABLESPACE HR_BIGTS READ ONLY;
	
Tablespace altered.

SQL> ALTER TABLESPACE HR_BIGTS READ ONLY;

Tablespace altered.

The tablespace can be put back into write mode later.

SQL> ALTER TABLESPACE HR_BIGTS READ WRITE;
	
Tablespace altered.

SQL> ALTER TABLESPACE HR_BIGTS READ WRITE;

Tablespace altered.