How to move Oracle database files to other location.
search cancel

How to move Oracle database files to other location.

book

Article ID: 238237

calendar_today

Updated On: 06-23-2025

Products

Data Loss Prevention Enterprise Suite Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

There is a need to move Oracle database files (datafiles) to other location say D partition as C is full.

Environment

Component : Oracle database 12c/19c Standard Edition. 

Cause

The space on C partition is full.

Resolution

The Oracle database standard edition does not support online moving/renaming datafiles to other location. The Oracle enterprise edition supports online moving datafiles to other location. 

After running following commands, if we attempt to move/relocate datafiles to other location, it will give us error like "ERROR at line 1: ORA-00439: feature not enabled: online move datafile"

1. SHUTDOWN IMMEDIATE

2. STARTUP MOUNT

3. ALTER DATABASE MOVE DATAFILE C:\ORACLE\ORADATA\PROTECT\USERS01.DBF TO C:\DBF\USERS01.DBF;