5> mv /u/product/oradata/foxmold/user01.dbf /db3/oradata
6> svrmgrl
7> connect internal
8> alter tablespace data rename datafile
‘/u/product/oradata/foxmold/user01.dbf’ to
‘/db3/oradata/user01.dbf’
9> alter database open
8. 統計分析
spool c:\analyze.sql
select 'analyze table '||trim(object_name)||' compute statistics; '
from user_objects
where object_type='table'
然后運行analyze.sql文件即可
