Oracle Database Tutorial 55: How to export tables using PARFILE in expdp Data Pump By Manish Sharma

Key Takeaways

what up internet I'm man from rebellionrider.com and I'm back once again with another Oracle database tutorial till so far we have seen how to export full database schema of the database and table spaces of the database the only export which remains left is table export thus in today's data pump tutorial we will learn how to export tables using expdp export but there is a Twist in today's tutorial in the previous three tutorials I demonstrated you the traditional way of exporting but today I will show you how you can perform the export of tables using parameter files in expdp utility so without further Ado let's start the tutorial like always first we need to make a directory you can create a directory anywhere in your system and give it a name this directory will serve as a default directory which will hold all the files created by expdp data pump utility such as dump file and lock file so let's create the directory I just created a directory and named it table export and I place this directory inside the folder data pump which is in the D drive thus the full path of our directory table export is D data pump table export next we will create a directory object as I have already explained in my previous tutorial that directory object is a pointer pointing over a directory which you want your expdp utility to use when storing all exported files so to make a directory object first we need to log onto our database using CIS user with CIS DBA privileges here I am now let's create the directory object but first let me clear the screen for you let's create the directory object let's hit the enter and execute the query directory created using this query we created a directory object and named it expore table this directory object will point the directory table export next we will grant the read and write privileges on the directory table export which we just created to the user who wants to perform the export for the demonstration I will use my user HR to perform the export you can you can use whatever user you want Grant succeeded apart from read and right you will also have to Grant data pump _ expore full database role to your user from which you are performing the export and as I already told you in my case this user is a CH Grant succeeded these are a few general settings which you have to do before performing the export next we have to create the parameter file param met file is just a simple text file which you can create anywhere in your system and give whatever name and extension you want though it's always recommended to give do p extension I will create my parameter file in my D drive let's come here and just go back now I am in my D drivve creation process is very simple just right click and select new and then text document now let's give it some name for the demonstration I have named it table. P next I will open this file with my notepad this file must contain all the required parameter of expdp data pum utility let's write it let's take a look of our parameter file first is the directory parameter which is set on the directory object expore table which we just created next is dump file parameter using which you can can set the name of your dump file you can give whatever name you want as I have given here HR table. DMP similarly using lock file parameter you can set the name of your lock file and the last parameter here is tables this parameter specifies that we want to perform a table mode export as I want to export employees and Department stable of my HR schema thus I have specified employees and Department stable as the value of this parameter similarly you can supply schema parameter or table space parameter if you want to do schema or table space this export but right now we want to export tables so let it be the table here save this file and close it again come to your command prompt now it's time to perform the export do remember to exit from your SQL prompt because we can execute expdp only on command prompt not on the SQL prompt okay as you can see right now I am on my command prompt let me clear the screen first okay now let's write the expdp export command command is fairly simple first we have our expdp utility followed by login information you cannot Supply login information in your parameter file and so you have to write your login information at the time of writing expdp command only then we have PAR file parameter the value of this parameter is the path of your parameter file let's execute this command as you can see export is successful please visit my blog here you can find the answers of questions like what is parameter file where should we create it and what are the naming conventions of parameter files also what are the contents of the parameter file along with all the commands which I have performed in this tutorial and the in-depth knowledge of this topic you can find the link of this blog in the description box hope you enjoyed this tutorial if yes then please hit the thumbs up button you can also comment your feedbacks and share the video and don't forget to subscribe as many more short crispy and interesting videos are coming to your way thanks for watching we'll see you soon till then take care this is Manish from Rebellion wrer