Oracle 11g tablespace dbf File migration

Oracle 11g tablespace dbf File migration

When the disk space of the Oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows:

1. sqlplus sys/sys as sysdba

2. shutdown immediate

3. copy the 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 the dbf file of the original tablespace, and the second is the new location.

6. alter database open;

7. If the following error is reported:

Row 3 has an error:

ORA-01113: file 9 requires media recovery

ORA-01110: data file 9: 'G: \ ORADATA \ HQBI \ efmweb03.dbf'

Run the following statement:

Recover datafile 'G: \ oradata \ hqbi \ efmweb03.dbf ';

Done!

Solutions for moving Oracle tablespace data files

Deleting temporary tablespace ORA-25152 Error

Oracle tablespace growth exception solution: Another example

Three parameters of Oracle tablespace Offline

Use of encrypted tablespace under Oracle 11 GB