--Moving Data Files: ALTER TABLESPACE
1. Take the tablespace offline.
2. Use an operating system command to move or copy the files.
3. Execute the ALTER TABLESPACE RENAME DATAFILE command.
4. Bring the tablespace online.
5. Use an operating system command to delete the file if necessary.
ALTER TABLESPACE usert1 OFFLINE --The tablespace must be offline.
commit
ALTER TABLESPACE USERT1--The target data files must exist.
RENAME
DATAFILE 'C:\ORACLE\ORADATA\USERT1.DBF'
TO 'C:\ORACLE\ORADATA\USERT1A.DBF'
ALTER TABLESPACE usert1 ONLINE
---Moving Data Files:ALTER DATABASE
1. Shut down the database.
2. Use an operating system command to move the files.
3. Mount the database.
4. Execute the ALTER DATABASE RENAME FILE command.
5. Open the database.
ALTER DATABASE RENAME
FILE 'C:\ORACLE\ORADATA\USERT1A.DBF'
TO 'C:\ORACLE\ORADATA\USERT1B.DBF'