Data Pump Export Import Over the Network using network_link

datapump network_link

In this article, we going to learn how to use the network_link parameter in oracle datapump export & import activity step by step. Case: 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 … Read more

How To Export Tablespace Using Expdp Data Pump Utility?

How To Export Tablespaces Using Expdp Data Pump Utility

Export Tablespace Using Expdp Hi, In this article we are going to learn how to export tablespaces using expdp data pump utility practically. What is tablespace? A tablespace is a logical unit of storage that is used by the database to store database objects like tables and PL/SQL codes. We can export tablespaces using the … Read more

How to split the datapump dumpfiles || limit the file size of dumpfile in Datapump

How to split dumpfiles

How to set limit the file size of dumpfile in Datapump? In this article we are going to discuss how to split the datapump dumpfiles, actually, the FILESIZE parameter is used to set limit the dumpfile size. For eg., if you want to limit your dumpfiles to 50m,  you can issue use the below command. Note:  The %u will … Read more