Monday , May 20 2024

How To Take Talespace Offline

In today’s article, we will be learning how to take an online tablespace offline so that it is temporarily unavailable for general use.

If a tablespace is made “Offline”, the data files belonging to that tablespace will also be offline.

When a tablespace is made “Offline”, the “CHECKPOINT” operation occurs.

When a tablespace is made ‘Online’ again, no “Media Recovery” process is required.

To Take a Tablespace Offline give the following command:

To again bring it back online give the following command.

Tablespace can also be made offline as “IMMEDIATE” if desired.

But in this case, the “Checkpoint” transaction does not occur.

In this case, it is necessary to perform media recovery.



Leave a Reply

Your email address will not be published. Required fields are marked *