How to copy tablespace from one database to another database in Oracle 11g How to copy tablespace and datafiles from one database to another database in Oracle 11g in same server ?
While copying a tablespace, it automatically includes data files and indexes associated with it. You need to make sure that tablespace is self contained.


Confirm that tablespace is self contained
execute DBMS_TTS.TRANSPORT_SET_CHECK('&lt;TABLESPACENAME&gt;', true);
Use the TRANSPORT_SET_VIOLATIONS view to check if any violations condition  exists
select * from TRANSPORT_SET_VIOLATIONS;
if any exist then fix them.
Make the tablespace read only
alter tablespace &lt;TABLESPACENAME&gt; read only;
Use EXPDP COMMAND to export the tablespace:

EXPDP USERNAME/PASSWORD DIRECTORY=DIRECTORYNAME DUMPFILE=DUMPFILE.DMP
LOGFILE=ERROR.LOG TRANSPORT_TABLESPACE=TABLESPACENAME


(You should have the rights necessary to execute IMPDP/EXPDP command and access rights to directory objects which map to the OS folder.) 
Copy the datafiles to the target database using ftp or scp or somt other filesystem utility.
Make the tablespace READ WRITE again in the source database
Use IMPDP command to import it into target database:

IMPDP USERNAME/PASSWORD DIRECTORY=DIRECTORYNAME DUMPFILE=DUMPFILENAME.DMP 
LOGFILE=ERROR.LOG

Check logfile for errors, if any
Make the tablespace read write in the target database:

ALTER TABLESPACE &lt;TABLESPACENAME&gt; READ WRITE