????????????????е??????????????·????????????·??
???????????offline?????????
???????????oracle?????????(EXAMPLE????)???????
????D:ORADATAORCL ????? D:ORACLEORADATA
????1.?????????????????????
????SQL> select tablespace_name??file_name??online_status
????from dba_data_files
????where tablespace_name='EXAMPLE';
????TABLESPACE_NAME FILE_NAME     ONLINE_
????--------------- ----------------------------------- -------
????EXAMPLE  D:ORADATAORCLEXAMPLE01.DBF  ONLINE
????2.??????????????????
????SQL> alter tablespace EXAMPLE offline;
????3.??β???????????????????????????
????SQL> select tablespace_name??file_name??online_status
????from dba_data_files
????where tablespace_name='EXAMPLE';
????TABLESPACE_NAME FILE_NAME     ONLINE_
????--------------- ----------------------------------- -------
????EXAMPLE  D:ORACLEORADATAEXAMPLE01.DBF OFFLINE
????4.?????????????????(????)???μ?·??
????SQL> host move D:ORADATAORCLEXAMPLE01.DBF D:ORACLEORADATA
????5.???????????????·??
????SQL> alter tablespace EXAMPLE
????rename datafile 'D:ORADATAORCLEXAMPLE01.DBF'
????to 'D:ORACLEORADATAEXAMPLE01.DBF';
????6.???????????????????????????
????SQL> select tablespace_name??file_name??online_status
????from dba_data_files
????where tablespace_name='EXAMPLE';
????TABLESPACE_NAME FILE_NAME     ONLINE_
????--------------- ----------------------------------- -------
????EXAMPLE  D:ORACLEORADATAEXAMPLE01.DBF OFFLINE
????7.??????????????
????SQL> alter tablespace EXAMPLE online;
????8.??????????
????SQL> select tablespace_name??file_name??online_status
????from dba_data_files
????where tablespace_name='EXAMPLE';
????TABLESPACE_NAME FILE_NAME     ONLINE_
????--------------- ----------------------------------- -------
????EXAMPLE  D:ORACLEORADATAEXAMPLE01.DBF ONLINE
???????:????????SYSAUX??USERS?????????
?????????????????
?????÷?????????????mount??
????1.????????е??????
????SQL> shutdown immediate
????2.????????mount??
????SQL> startup mount
????3.?????????(SYSTEM????)?????????
????SQL> host move D:ORADATAORCLSYSTEM01.DBF D:ORACLEORADATA
????4.???????????????·??
????SQL> alter database rename file 'D:ORADATAORCLSYSTEM01.DBF' to 'D:ORACLEORA
????DATASYSTEM01.DBF';
????5.?????????????
????SQL> alter database open;
????6.???????????
????SQL> select tablespace_name??file_name??online_status from dba_data_files where ta
????blespace_name='SYSTEM';
????TABLESPACE_NAME FILE_NAME     ONLINE_
????--------------- ----------------------------------- -------
????SYSTEM  D:ORACLEORADATASYSTEM01.DBF SYSTEM
???????:????????UNDOTBS1??TEMP????????á?
??????????????С??????????Oracle????????????????????????????????