Monday , May 20 2024

How To Add The Datafile To Tablespace

In today’s article, we will be discussing the question of how to add a data file to the tablespace in Oracle?

1. We learn columns and data types from dba_data_files.

We can find out whether dba_data_files is a view or a table as follows.

In TOAD, we type dba_data_files on the editor screen and move the cursor over dba_data_files while holding down Ctrl. It becomes active as a link. When we click it, its details open.

It can also be found from SQLplus as follows.

2. The following query is run to see where the tablespaces to be added are located.

2. The following query is run to see where the tablespaces to be added are located.

3. We find out whether there is room in the section we will add.

4. We use the following query to see how much space is allocated for the tablespace and the maximum size of the tablespace.

5. After learning all this, the datafile is added to the tablespace with the following query.

6. If the ratio does not appear in the dba tablespace view, manual calculation is made below.

Loading

About Onur ARDAHANLI

Leave a Reply

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

Categories