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: [email protected]
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