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: https://ocptechnology.com/datapump-network-link/
#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
👉https://t.me/ocptechnology
Chat with me on:
👉Join WhatsApp Group: https://whatsapp.com/channel/0029VaS09Y64NViipTPpxt1q
👉Join Telegram Group: https://t.me/+GyzG3cZgs3I4NWI1
MY Gadgets:
Mic https://amzn.to/3lYLBW8
Laptop https://amzn.to/3ndktCa
Mouse https://amzn.to/3jn58Ok
Oracle Interview application https://play.google.com/store/apps/de...
Facebook page https://www.facebook.com/ocptechnology
Instagram https://www.instagram.com/digitalshripal/
Website http://ocptechnology.com/
Twitter https://twitter.com/ocptechnology
