limitations

same platform and version

need have same users on destination because users go with the tablespces

steps
• check constraints and self-sufficency
  DBMS_TTS checks if the tablespaces are transportable.
  EXECUTE DMBS_TTS.TRANSPORT_SET_CHECK('AP_DATA,AP_INDEX',TRUE); does such a check for these two tablespaces. TRUE means check constraints.
• alter tablespace ap_data read 0nly
• alter tablespace ap_index read 0nly
• Exp transport_tablespace=y tablespaces=ap_data,ap_index triggers=y constraints=y grants=y file-tts.dmp
• cp ap_data /new/destination
• cp ap_index /new/destination
• import into the new database
  Imp transport_tablespace=y datafiles=(d:\oracle\ap_db\data\ap_data01.dbf,e:\oracle\ap_db\data\ap_index.dbf) file=tss_dmp tablespaces=(ap_data,ap_index) owners=(ap_dba);
• ALTER TABLESPACE ap_data READ WRITE
• ALTER TABLESPACE ap_index READ WRITE