HomeОбразованиеRelated VideosMore From: Manish Sharma

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

183 ratings | 25773 views
In this Oracle Tutorial you will learn how to export tables of the database using Parameter File (PARFILE) in Data Pump expdp export utility. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/expdp-parfile-table-mode-export Previous Tutorial Tut 52 Expdp Full Database http://youtu.be/K8_PjUksT54 Tut 53 Expdp Tablespace http://youtu.be/-hXBZd-FCjs Tut 54 Expdp Schema http://youtu.be/t8TSLDGN5gg ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (13)
mahesh Kumar (6 months ago)
simple and clear
Usha Subramanian (1 year ago)
Hi Manish, In a multi-tenant application, While exporting tables from a database , can we use filters in the Par file like for example: Schemaname.Table_name where Enterprise_id = 100
hasan yousef (1 year ago)
Hello Manish Sharma i wolud like to thank you about this lessons i face ERROR when i execute expdp user/[email protected] parfile='--' the error: LRM-00109: could not open parameter file 'C:\table.par' LRM-00113: error when processing file 'C:\table.par' can you help me please thank you agian Hasan
Saif Kalu (1 year ago)
do not give semi-colon(;)
Mahi khancse20 (1 year ago)
facing same problem , but i can't find out proper reason. do u find any solution ?? hasan yousef
Shashwat bansal (1 year ago)
Now I am feeling to learn ORACLE DBA easily and quick that help me in my job work. Will like to connect with you for further doubts as DBA fresher.
Johnny Phan (2 years ago)
Thank you, Manish...
BATANA ferdinand (2 years ago)
very helpful tanks
Manish Sharma (2 years ago)
+BATANA ferdinand It is always a great pleasure. Thanks for the appreciation. Keep watching. Have a great day
Shilpa Dorle (2 years ago)
Hi Manish, Do indexes and constraints get copied automatically with table export or do have to explicitly do that?
mayur dubey (3 years ago)
Hi Manish , while creating the par file it is stil showing as text file format instead of par format even after naming it to table.par . any fix for this ??
Ramesh Doosa (3 years ago)
thank you so much Mr. Manish...
Shrikant Goud (3 years ago)
Hey Manish, can we export/import stored procedure, functions too??? if yes, can u pls explain/ load a video for the same?

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.