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, 1670🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...