Export and Import tablespace on same database

export the single tablespace
expdp system/orcl directory=DATA_PUMP_DIR dumpfile=testtablespace.dmp logfile=testtablespace.log tablespaces=users


export the single tablespace 
expdp system/orcl directory=DATA_PUMP_DIR dumpfile=testtablespace.dmp logfile=testtablespace.log tablespaces=users,test


export tablespace with-out index (10x faster if we include index)**
expdp system/orcl directory=DATA_PUMP_DIR dumpfile=testtablespace.dmp logfile=testtablespace.log tablespaces=users,test exclude=indexes*

Drop the all users related to same tablespace.
If you try to import the dump, without dropping the users, then impdp fails with error
"ORA-39151. "All dependent metadata and data will be skipped due to table_exists_action of skip"




solution to above error "table_exists_action=replace"
impdp system/orcl directory=DATA_PUMP_DIR dumpfile=testtablespace.dmp logfile=testtablespace.log tablespaces=users table_exists_action=replace
or
impdp system/orcl directory=DATA_PUMP_DIR dumpfile=testtablespace.dmp logfile=testtablespace.log tablespaces=users,test  table_exists_action=replace
or
impdp system/orcl directory=DATA_PUMP_DIR dumpfile=testtablespace.dmp logfile=testtablespace.log tablespaces=users,test exclude=indexes  table_exists_action=replace


 
Note - ** soon script will provided to collect all inde.
       * collect all index to some source, either you will lost your indexes.