oracle数据文件管理
FILE# NAME STATUS ---------- ------------------------------ -------1 /oracle/CRM2/CRM/system01.dbfSYSTEM
2 /oracle/CRM2/CRM/zxb.dbf OFFLINE
3 /oracle/CRM2/CRM/sysaux01.dbfONLINE
4 /oracle/CRM2/CRM/users01.dbf ONLINE
5 /oracle/CRM2/CRM/zxa.dbf OFFLINE
6 /oracle/CRM2/CRM/undotbs2.dbfONLINE
7 /oracle/CRM2/CRM/zxc.dbf OFFLINE
8 /oracle/CRM2/CRM/zxbig1.dbf ONLINE
在操作系统上拷贝数据文件到目标位置：
SQL> host;
$ cp /oracle/CRM2/CRM/zx*.dbf /oracle/CRM2/
$ ls -l /oracle/CRM2/
total 2213032
-rw-r----- 1 oracle oinstall104865792 Nov2 22:37 zxa.dbf
-rw-r----- 1 oracle oinstall 10493952 Nov2 22:37 zxb.dbf
-rw-r----- 1 oracle oinstall 1056768 Nov2 22:39 zxc.dbf
使用alter tablespace ........rename datafile 语句改变数据文件位置
语句：alter tablespace zx
rename datafile'/oracle/CRM2/CRM/zxa.dbf',
'/oracle/CRM2/CRM/zxb.dbf',
'/oracle/CRM2/CRM/zxc.dbf'
to '/oracle/CRM2/zxa.dbf',
'/oracle/CRM2/zxb.dbf',
'/oracle/CRM2/zxc.dbf';
SQL>> 2 rename datafile'/oracle/CRM2/CRM/zxa.dbf',
3 '/oracle/CRM2/CRM/zxb.dbf',
4 '/oracle/CRM2/CRM/zxc.dbf'
5 to '/oracle/CRM2/zxa.dbf',
6 '/oracle/CRM2/zxb.dbf',
7 '/oracle/CRM2/zxc.dbf';
页:
[1]