Let us we discuss about how to relocate tablespace ?

S-1: check the tablespace available on database

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
-------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE 
B

here i m going to relocate the tablespace "B" from one place into another

S-2: To view the datafile location

SQL> select file_name from dba_data_files where tablespace_name='B';

FILE_NAME
----------------------------
/u01/app/oracle/product/11.2.0.3/oradata/TEST/b.dbf

S-3: take the tablespace offline before we ll do relocate

SQL> alter tablespace B offline;

Tablespace altered.

S-4:

[oracle@oracle11g ~]$ cd /u02
[oracle@oracle11g u02]mkdir test
[oracle@oracle11g u02] cd test
[oracle@oracle11g test]mv /u01/app/oracle/product/11.2.0.3/oradata/b.dbf  /u02/test/b.dbf

S-5:

alter tablespace b rename datafile '/u01/app/oracle/product/11.2.0.3/oradta/b.dbf' ro '/u02/test/b.dbf';

S-6:

SQL>alter tablespace b online;

S-7:

SQL>select file_name from dba_data_files where tablespace_name= 'B';

in these method tablespace has been relocated during database is running