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, 3644🔥, 0💬
Popular Posts:
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...