launch sqlplus

connect as sys

the following are the commands to enter.


1. alter tablespace users offline;

2. from your operating system prompt copy files from
current location to new location.
(eg. in windows we copy from d drive to e drive
copy d:\oracle\oradata\test\users01.dbf e:\oracle\oradata\test
)

3. alter database rename file 'd:\oracle\oradata\test\users01.dbf' to 'e:\oracle\oradata\test\users01.dbf' ;

4. alter tablespace users online;


and very important step is read oracle documentation,
if you want to continue as oracle DBA.

-Raja