Collections:
Bring a Tablespace Online in Oracle
How To Bring a Tablespace Online in Oracle?
✍: FYIcenter.com
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 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created. SQL> ALTER TABLESPACE my_space OFFLINE NORMAL; Tablespace altered. ... SQL> ALTER TABLESPACE my_space ONLINE; Tablespace altered.
⇒ Add Another Datafile to a Tablespace in Oracle
⇐ Bring a Tablespace Offline in Oracle
2019-01-01, 1825🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...