Methods for Moving Data Files移动数据文件的方法

Methods for Moving Data Files移动数据（只是更改指针）文件方法一

? ALTER TABLESPACE

– Tablespace must be offline.

– Target data files must exist.

ALTER TABLESPACE userdata RENAME

DATAFILE '/u01/oradata/userdata01.d

TO '/u02/oradata/userdata01.dbf';

Steps to rename a data file:

1. Take the tablespace offline.

2. Use an OS command to move or copy the files.

3. Execute the ALTER TABLESPACERENAME DATAFILE command.

4. Bring the tablespace online.

5. Use an OS command to delete the file if necessary.

Methods for Moving Data Files移动数据文件方法二

? ALTER DATABASE

– Database must be mounted.

– Target data file must exist.

ALTER DATABASE RENAME

FILE '/u01/oradata/system01.dbf'

TO '/u03/oradata/system01.dbf';

The ALTER DATABASE command can be used to move any type of data file:

ALTER DATABASE [database]

RENAME FILE 'filename'[, 'filename']...

TO 'filename'[, 'filename']...

Because the SYSTEM tablespace cannot be taken offline, you must use this method

to move data files in the SYSTEM tablespace.

Use the following process to rename files intablespaces that cannot be taken offline:

1. Shut down the database.

2. Use an operating system command to move the files.

3. Mount the database.

4. Execute the ALTER DATABASE RENAME FILE command.

5. Open the database.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29840459/viewspace-1467235/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29840459/viewspace-1467235/