ORACLE11 table space DBF File Migration

When the disk space for Oracle's data files is not sufficient or otherwise requires that the DBF file be migrated to a different location, here are the steps:

1, Sqlplus Sys/sys as Sysdba

2, Shutdown immediate

3. Copy dbf file to a new location

4, startup Mount;

5, ALTER DATABASE rename file ' E:\oracle\oradata\hqbi\EFMWEB03. DBF ' to ' G:\oradata\hqbi\EFMWEB03. DBF ';

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

6, ALTER DATABASE open;

7. If the following error is reported:

An error occurred on line 1th:
ORA-01113: File 9 requires media recovery
ORA-01110: Data file 9: ' G:\ORADATA\HQBI\EFMWEB03. DBF '

You need to execute the following statement:

Recover DataFile ' G:\oradata\hqbi\EFMWEB03. DBF ';

Get!