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/