个人博客创业记录-oracle metalink账号|Oracle Metalink账号注册指南

表空间数据文件移动或改名操作

sqlplus /nolog

SQL> conn /as sysdba

SQL> alter tablespace <tablespace name> oforacle账号fline;

SQL> host mv <old file name> <new file name>

SQL> alter tablespace <tablespace name> rename datafile '<old file name>' to '<new file name>';

SQL> alter tablespace <tablespace name> online;

SQL> exit