How To Bring a Tablespace Online

Q

How To Bring a Tablespace Online? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files

✍: FYIcenter.com

A

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.

2007-05-03, 5022👍, 0💬

How To Bring a Tablespace Online
How To Bring a Tablespace Online? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files 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/fyicente... 2007-05-03, 5023👍, 0💬

How To Add Another Datafile to a Tablespace
How To Add Another Datafile to a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you created a tablespace with a data file a month ago, now 80% of the data file is used, you should add another data file to the tablespace. This can be done by using the ALTER TABLESPACE ..... 2007-05-03, 4891👍, 0💬

What Happens to the Data Files If a Tablespace Is Dropped
What Happens to the Data Files If a Tablespace Is Dropped? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If a tablespace is dropped, what happens to its data files? By default, data files will remain in OS file system, even if the tablespace they are mapped is dropped. Of course, you... 2007-05-03, 4783👍, 0💬

What Is the Relation of a User Account and a Schema
What Is the Relation of a User Account and a Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the ... 2007-05-02, 4686👍, 0💬

How To See Free Space of Each Tablespace
How To See Free Space of Each Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files 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... 2007-05-03, 4680👍, 0💬

How Remove Data Files befor opening a Database
How Remove Data Files befor opening a Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline befor o... 2007-05-02, 4674👍, 0💬

How To Drop a Tablespace
How To Drop a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you have an existing tablespace and you don't want it anymore. You can delete a tablespace by using the DROP TABLESPACE statement as shown in the example below: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/tem... 2007-05-03, 4595👍, 0💬

How To Create a Table in a Specific Tablespace
How To Create a Table in a Specific Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLES... 2007-05-03, 4580👍, 0💬

How To Bring a Tablespace Offline
How To Bring a Tablespace Offline? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files 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 ... 2007-05-03, 4569👍, 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.