Data Pump Export Import Over the Network using network_link

Опубликовано: 11 Октябрь 2024
на канале: OCP TECHNOLOGY
3,451
123

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-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
👉https://t.me/ocptechnology

Chat with me on:
👉Join WhatsApp Group: https://whatsapp.com/channel/0029VaS0...

👉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   / ocptechnology  
Instagram   / digitalshripal  
Website http://ocptechnology.com/
Twitter   / ocptechnology