There is a need to move Oracle database files (datafiles) to other location say D partition as C is full.
Component : Oracle database 12c/19c Standard Edition.
The space on C partition is full.
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;