Oracle - Bring a Tablespace Offline in Oracle

Bring a Tablespace Offline in Oracle

Q

How To Bring a Tablespace Offline in Oracle?

✍: FYIcenter.com

A

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.

⇒Managing Oracle Tablespaces and Data Files

⇒⇒Oracle Database Tutorials

2019-01-01, 583👍, 0💬

💬 2019-01-08 Bvm: Help :)

Create a Server Parameter File in Oracle
How To Create a Server Parameter File in Oracle? This is Step 5. The initialization parameter file is good to get an Oracle database instance started. But it is not ideal run an instance as production. You need to convert the initialization parameter file into a Server Parameter File (SPFile) using ... 2018-05-08, 693👍, 0💬

Bring a Tablespace Online in Oracle
How To Bring a Tablespace Online in Oracle? If you have brought a tablespace offline, now you want to make it available to users again, you can use the ALTER TABLESPACE ... ONLINE statement as shown in the following script: SQL> connect HR/fyicenter SQL> CREATE TABLESPACE my_space 2 DA... 2019-01-01, 591👍, 0💬

Bring a Tablespace Offline in Oracle
How To Bring a Tablespace Offline in Oracle? 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/... 2019-01-01, 584👍, 0💬

Show Free Space in a Tablespace in Oracle
How To See Free Space of Each Tablespace in Oracle? One of the important DBA tasks is to watch the storage usage of all the tablespaces to make sure there are enough free space in each tablespace for database applications to function properly. Free space information can be monitored through the USER... 2019-01-01, 426👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.