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, 1787🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you nee...