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, 1744🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......