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: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
17 авг 2020
