Monday , May 20 2024

Renaming And Moving Data Files

In this article presents a brief explanation of how assorted Oracle data files can be renaming and moving to a new location.

Data files may need to be moved or renamed for the following reasons:

-To give names that comply with naming standards,

-To free up space on a full disk,

-To move a data file that was mistakenly created on the wrong disk, etc.

For this process, first the tablespace must be made offline or the database must be closed.

Process steps:

1. Tablespace is put into offline mode;

2. The transfer process is carried out via the operating system.

3. We are updating CONTROL FILE;


4. Tablespace is done online.



Leave a Reply

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