Collections:
Bring a Tablespace Offline in Oracle
How To Bring a Tablespace Offline in Oracle?
✍: FYIcenter.com
If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script:
SQL> connect HR/fyicenter Connected. SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created. SQL> ALTER TABLESPACE my_space OFFLINE NORMAL; Tablespace altered.
After bringing a tablespace offline, you can backup or rename the data file safely.
⇒ Bring a Tablespace Online in Oracle
⇐ Show Free Space in a Tablespace in Oracle
2019-01-01, 1696🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...