Oracle 11g DBF data file migrated from C drive to D drive

Server System for Windows R2 64-bit, because the C disk space will be full, to the C-disk of the Oracle DBF data file to migrate to the D disk, the steps are as follows:

1. Enter CMD to start the Cmd.exe window

2. Enter Sqlplus/nolog

3. Input conn Sys/[email protected] as Sysdba

4. Enter sql:select name from V$datafile;

View the relevant data file storage path

5. Shutdown immediate Off

6. Startup Mount;

7. Alter DATABASE rename file ' C:\app\Administrator\oradata\orcl\USERS01. DBF ' to ' D:\ORADATA\USERS01. DBF ';

The first file is a DBF file for the original tablespace, and the second is the new location

If there are multiple, repeat the 7th step

8.alter database open;   If the error is entered first: Recover database; Re-enter ALTER DATABASE open;

9. Re-enter select name from V$datafile; See if the changes have been made.

Oracle 11g DBF data file migrated from C drive to D drive