How to copy a tablespace to another database without using Data Pump in Oracle 11G
This is the bare minimum assuming the simplest scenario.

1. Original export/import:

Source database:


export everything from the tablespace


exp userid=user/password tablespaces=example file=example.dmp

Destination:


copy example.dmp from source
create empty tablespace at the desired location, create users manually, then:


imp userid=user/password full=y file=example.dmp

or 2. Transportable tablespace with original export/import:

Source database:


put tablespace into read only mode:


alter tablespace example read only;


export metadata for transporting the tablespace


exp userid=\'/ as sysdba\' transport_tablespace=y tablespaces=example file=example_tts.dmp

Note that you get an EXP-00044 error here if you do not connect with SYSDBA.

Destination database:


copy example_tts.dmp from source
copy the datafile itself from source to the desired location (example01.dbf in below example)
create users manually, then:


imp userid=\'/ as sysdba\' transport_tablespace=y datafiles=/oradata/S112/example01.dbf file=example_tts.dmp


finally make the tablespace writable:


alter tablespace example read write;

More details can be found in the documentation:

Original Export

Original Import