To modify the file path for an oracle tablespace ____oracle

Reason for writing:
1. Oracle instance is created on 91.
2. In order to solve the problem of importing SDE user error without creating the SDE service pilot data, the sequence of data is introduced after the first SDE service is created.
3, because 91 of the ArcGIS version on the machine is 9.3, in order to ensure the release of the version of the site can be used normally, so, on other machines for 91 to create SDE table space and users.
(Set up a shared directory on 91, permissions writable, \\192.168.0.91\WLMQ.) ）
4, because it is remotely created, through "select file_name from dba_data_files where tablespace_name = ' SDE ';" You can view the datafile in the SDE as the "\\192.168.0.91\WLMQ\SDE" path to the database. DBF ".
5, cancel the sharing, the database can not start normally, view the startup log under Bdump, the error message is: Unable to find the database file \\192.168.0.91\WLMQ\SDE. Dbf. Workaround:
1. Re-share the directory, and the permissions can be written.
2, start the database and console services.
3, login to the console, find SDE table space, modified to offline.
4, Sqlplus Connection database, execute the following sql:
Alter tablespace SDE rename DataFile ' \\192.168.0.91\WLMQ\SDE. DBF ' to ' D:\ORACLE\PRODUCT\10.2.0\ORADATA\WLMQ\SDE. DBF ';
5, after the prompt modification succeeds, Plsql executes "select file_name from dba_data_files where tablespace_name = ' SDE ';", can be viewed to SDE datafile the path to the database has been modified to "D : \oracle\product\10.2.0\oradata\wlmq\sde. DBF ".
6, Cancel directory sharing, restart the database, check the database can be used for normal connection.