How To Bring a Tablespace Online?
Page 1 of 1
How To Bring a Tablespace Online?
by Micheal Tue Jan 19, 2010 7:25 pm
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.
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.
Micheal- Admin
- Posts : 243
Join date : 2010-01-10 -
Similar topics» How To Add Another Datafile to a Tablespace?
» How To See Free Space of Each Tablespace?
» What Is an Oracle Tablespace?
» How To Create a New Tablespace?
» How To Rename a Tablespace?
» How To See Free Space of Each Tablespace?
» What Is an Oracle Tablespace?
» How To Create a New Tablespace?
» How To Rename a Tablespace?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Accessing tables of other users in SQL
» Grouping commands in SQL
» Operations on Result Sets in SQL
» Subqueries in SQL
» Joining Relations in SQL
» Delete comand in SQL
» Update command in SQL
» Insert command in SQL