Sometimes we need to move a table or schema from one database to another database but don’t have sufficient disk space on the production server. As you know the dump file takes a lot of space on the disk.
So, the network_link parameter helps us to solve our disk space problem. Using the DB Link parameter we can perform the export and import over the network and very easily move a table or schema from an oracle database to another Oracle database very easily.
Blog Link: ocptechnology.com/datapump-ne...
#datapump #dblink #oracle #oracledatabase #oracledba #oracledb #oracledbwr #dba
00:00 Introduction
01:22 Create sample schema & table
02:20 Create TNS service
02:55 Create directory target side
03:20 Create DB link target side
03:30 Perform Import directly using a DB link
04:46 perform the export Backup on target side
Join Our Official Telegram Channel
👉t.me/ocptechnology
Chat with me on:
👉Join WhatsApp Group: whatsapp.com/channel/0029VaS0...
👉Join Telegram Group: t.me/+GyzG3cZgs3I4NWI1
MY Gadgets:
Mic amzn.to/3lYLBW8
Laptop amzn.to/3ndktCa
Mouse amzn.to/3jn58Ok
Oracle Interview application play.google.com/store/apps/de...
Facebook page / ocptechnology
Instagram / digitalshripal
Website ocptechnology.com/
Twitter / ocptechnology