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

Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp

589 ratings | 81538 views
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 (48)
Ramesh Thamizhselvan (1 year ago)
This is very crystal clear i like the speed of this tutorial.
Maasai Maasai (7 days ago)
This is very clear man. very straight.
Manish Sharma (6 days ago)
Thank you so much.
Azeem Khan (1 month ago)
absolutely beautiful.
Manish Sharma (1 month ago)
Thank you so much
pankaj todkar (4 months ago)
Hi thanks Manish ! To create a dmp file for .5 TB using expdp. how much time would it take using parallel option ?? Do I need not to log archived?
gigijaponezu (7 months ago)
Short and concise. I love the way you presented the export action! I learned more during this video then in the last 2 hours, thanks a lot!
Zainab Amir (1 year ago)
Thank you Manish for sharing this in easy and clear way.
Sayma Inamdar (1 year ago)
C:\>expdp system/[email protected] DIRECTORY=sam DUMPFILE=xefull.dmp LOGFILE=samxe.log FULL=YES; LRM-00105: 'YES;' is not a legal Boolean for 'full' any idea?
Fabio Dominguez (9 months ago)
try C:\>expdp user/[email protected]/servicename full=Y DIRECTORY=orcl_full DUMPFILE=orclfull.dmp LOGFILE=full_exp.log;
Praveen Raj Kumar.Y x (1 year ago)
I'm facing the same problem as like Sayma. @Manish, could you please help us here? Thanks in advance!
Amit Balan (1 year ago)
is it for sql developer also
Steve Masinde (1 year ago)
Thanks, Started following your tutorials
blueboy334 (1 year ago)
Thank you Manish...great vid...your help is very much appreciated.
Yeji You (1 year ago)
Hi Manish, I am not sure if I can ask this for you but it would be really grateful if you have any answer of my question. I did full database using expdp following your description and got some error like this : ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name "DW00" prematurely terminated ORA-31671: Worker process DW00 had an unhandled exception. ORA-00600: internal error code, arguments: [qctchr : bfl], [400], [100], [1], [846], [1], [0], [], [], [], [], [] ORA-06512: at "SYS.KUPW$WORKER", line 1714 ORA-06512: at line 2
KARAN KYATAM (1 year ago)
Veer Dahinwal (2 years ago)
I am trying to run export (expdp) in a Windows environment, and I am getting these errors: ORA-39002: invalid operation dbms_datapump.get_status(178...) ORA-39002: invalid operation ORA-39070: unable to open the log file. ORA-29283: invalid file opertion ORA-06512: at "SYS.UTL_FILE", line 536 ORA-29283: invalid file operation
Mohammad Mannan (2 years ago)
hai manish whan i am expdp it vl take more then 30 minute to load the data ...that is also emp table ...pls can u tell me y its takinng long time to load ...pls tell me what is the resion ...i am using windows 8.1 ....9642374757 this my what up no ....pls tell
Thameem Ansari (2 years ago)
The description part which is a side note is a good approach.
you are best tutor
Kamalendu Roy (2 years ago)
Thank you Manish
Marcio Carvalho (2 years ago)
Ashish Burnwal (2 years ago)
You have really explained in very elegant way :) Thank you.
Rammosh (2 years ago)
thank you very much that was very helpfull
Sanjeet Kumar (2 years ago)
You are gem, my dear friend, thanks a lot
Hassan Ameer Ali (2 years ago)
Yo man good
Xuân Hoàng Nguyễn (3 years ago)
thank you manish, you're great ! i've followed you everywhere to learn more Oracle, hope to see you once in my life :)
Xuân Hoàng Nguyễn (3 years ago)
Can you guide me how to expdp/impdp for multi files dmp multi tables ? ex: table1.dmp - table 1 only table2.dmp - table 2 only all in one command, each dmp for every table I want to exp/imp
Manish Sharma (3 years ago)
Thanks a lot for this lovely comment. I am really glad for your love and support.
amit dubey (3 years ago)
Hi manish, could you please share the video for database refrsh incuding concept of refresh? Thanks,
Rəşad Mehdiyev (3 years ago)
I have a problem expdp sys/[email protected] directory=orcl_full dumpfile=exp_sys.dmp logfile=exp_sys.log full=yes ; ORA-12514: TNS:listener does not currently know of service requested in connect descriptor please help me
Muhammad Shoaib (1 year ago)
Check the name of your global_variable by using the command: select * from global_name; and use it in place of orcl in hr/[email protected]
Faran Zafar (3 years ago)
LRM-00105: 'YES;' is not a legal Boolean for 'full' Everything is as per the video but why this error is coming ?
Akbar Yuldoshev (3 years ago)
Thank u Manish for very informative series of videos
Manish Sharma (3 years ago)
+Akbar Yuldoshev It's a huge pleasure that you find my videos helpful. Please do make sure to like and share with your friends.
Ayoob manker (3 years ago)
Hi Manish , im using 12c when im going to Export getting this error ORA-12154: TNS:could not resolve the connect identifier specified.... please advice me
Muhammad Shoaib (1 year ago)
Check the name of your global_variable by using the command: select * from global_name; and use it in place of orcl in hr/[email protected]
Nikhil Inamdar (3 years ago)
nice explanation..happy :):)
Nigamananda Bindhani (3 years ago)
Hello Manish Thank u so much for your awesome tutorial I have an issue export full database using #expdp export data pump utility then i got an error like operation generated oracle error 12154 please help me how can i find my error. Thank U
smaug smaug (4 years ago)
Hi manish. first at all thank u From Colombia  for this tutorials. I have one question. If I have a .dmp bk that was taken from the exp command (not expdp) , I wanna know the differences with expdp and also if this contains all data from db. Specially When I see the log file I can see clearly that the tables were exported with synonyms,views,store procedures..etc.. but I cant see the table spaces and schemes My concern is that right now Im implementing a test envoirament from scrath (I just isntall oracle following you tutorial) and they ask me to restore this .dmp backup in this new server. I saw the .bat file that  they use for the backup and they use exp tool with this syntax: C:\app\user\product\11.2.0\dbhome_1\BIN\EXP USERID=User\[email protected] file=D:\bkoracle\oracle001_xxx.DMP log=D:\bkoracle\oracle001_xxx.LOG buffer=2000000 owner:User can I restore using expdp tool and all the db will be complete ?
mayur dubey (4 years ago)
Hi Manish  , iam new to the oracle DBA field and your videos are really helpful for the beginner.....and easy to understand...thank you ..for this ,,,thumbs up  :)
Kim Rasmey (4 years ago)
Thx you very much your video very very help full for me :D
Sandeep Jha (4 years ago)
 Manish, can you post  some tutorial on how to write procedures in Oracle ?
Haikal Halim (4 years ago)
good tutorial
Ayman Alsapagh (4 years ago)
Ayman Alsapagh (4 years ago)
@Manish Sharma  and i'm so happy following u 
Manish Sharma (4 years ago)
@ayman alsayed Thanks for the thumbs up :-) hope you are enjoying my videos. Your feedback means a lot to me. 

Would you like to comment?

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