Oracle Mobile Data/modify data file path

Reference: http://wwyz998.blog.163.com/blog/static/321867852011117111832334/

Oracle Mobile data Files

1. Connect to a database

[Email protected]]$./sqlplus/nolog

Sql> Conn/as SYSDBA

2. View the data file location

Sql> select file_name from Sys.dba_data_files;

Or

sql> select name from V$datafile;

file_name

------------------------------------------------------------------------

/oradata/pmptgdb/users01.dbf

/oradata/pmptgdb/undotbs01.dbf

/oradata/pmptgdb/sysaux01.dbf

/oradata/pmptgdb/system01.dbf

/oradata/pmptgdb/work.dbf

2. Close the database

sql> shutdown immediate;

4. Move the file to a new location (for example, the new location is/media/hdd1/oradata/pmptgdb)

cd/oradata/pmptgdb/

MV users01.dbf undotbs01.dbf sysaux01.dbf system01.dbf work.dbf/media/hdd1/oradata/pmptgdb

5. Starting the database in Mount mode

sql> startup Mount;

sql> ALTER DATABASE rename file '/oradata/pmptgdb/users01.dbf ' to '/media/hdd1/oradata/pmptgdb/users01.dbf ';

Repeat for each file that you want to move the ALTER DATABASE rename file ... to ...

6. Open the Database

sql> ALTER DATABASE open;

Check the file location again and find that it is more.

Oracle Mobile Data/Modify data file path