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, 1746🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...