--9i migration data file process
View view
SELECT * FROM DBA_DATA_FILES
Determine the data file "location" and "name" to be moved
Source location and name: '/Home/oracle/product/92/oradata/adp/Users02.dbf'
Target location and name: '/Home/oracle/oradata/adp/users02.dbf'
2. Stop the database
Shutdown immediate;
3. Copy source data files to the development location
CD / Home / Oracle / Product / 92 / ORADATA / ADP / CP USERS02.DBF / Home / Oracle / ORADATA / ADP /
4. Start the database to MOUNT status
Startup mount;
5. Move data files
Alter Database Rename file '/Home/oracle/product/92/oradata/adp/Users02.dbf' to '/Home/oracle/oradata/adp/Users02.dbf'
