Transportable Tablespace in Oracle - TTS - Database Migration Using TTS Simple Steps

We have 2 database in 2 different pc

S1=
—
ip address : 192.168.0.181
hostname : pc181.oracle.com

SID : catdb
Now create tablespace (sales) , create a user with default tablespace sales
login as new user create a table , insert few records.commit it.

our target transport this tablespace (sales) to another pc (T1)

sales tablespace=datafile+metada(datafile copy to 2nd pc by scp/ftp….and metadat by expdp)


$ expdp system directory=data_pump_dir dumpfile=sales.dmp transport_tablespaces=sales


T1=
—
—
ip address : 192.168.0.182
hostname : pc182.oracle.com

SID : prod

sales datafile location /u01/app/oracle/oradata/prod/sales01.dbf
sales.dmp dumpfile location data_pump_dir(/u01/app/oracle/admin/catdb/dpdump/sales.dmp)

now use impdp to insert metadata to local db datadictioary and relation between data and metadata)

check my video and steps::::

#TTS #TransportableTablespace #Migration

Please do follow me and support me on,

LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg


Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg