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

Подписаться 109 тыс.

Просмотров 134 тыс.

50% 1

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: bit.ly/database-full-export-us...
Tut 48 Roles: • SQL tutorial 48: How t...
-------------------------------------------------------------------------
►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
/ rebellionrider
/ imthebhardwaj
/ rebellionrider
plus.google.com/+Rebellionrider
/ mannbhardwaj
/ rebellionrider
/ rebellionrider
You can also Email me at
RebellionRiderYT@gmail.com
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

Опубликовано:

15 ноя 2014

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 65

@rameshthamizhselvan2458 6 лет назад

This is very crystal clear i like the speed of this tutorial.

@SATORvii 5 лет назад

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!

@user-iq4vg6ct2z 18 дней назад

Thank you so much for the video I have been looking for this information for a week.

@vidmayur 9 лет назад

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 :)

@ZainabSaleh85 6 лет назад

Thank you Manish for sharing this in easy and clear way.

@stevemasinde7207 6 лет назад

Thanks, Started following your tutorials

@blueboy334 6 лет назад

Thank you Manish...great vid...your help is very much appreciated.

@theans786 7 лет назад

The description part which is a side note is a good approach.

@mgc30 7 лет назад

MUITO OBRIGADO!!!! VC É DEMAIS. MUITO SHOW.

@otip3604 5 месяцев назад

Hi Manish, thank you for this video. you explained well the functions of those command and not letting us copy and execute without knowing what is the uses for each. you gained a sub from me.

@vongsiloryongpao6026 2 года назад

Loved it !!! Thanks for sharing ...

8 лет назад

thank you manish, you're great ! i've followed you everywhere to learn more Oracle, hope to see you once in my life :)

@Rebellionrider 8 лет назад

Thanks a lot for this lovely comment. I am really glad for your love and support.

8 лет назад

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

@kimrasmey4568 9 лет назад

Thx you very much your video very very help full for me :D

@ReemAlissa 7 лет назад

thank you very much that was very helpfull

@SanjeetKumar-ch4wq 7 лет назад

You are gem, my dear friend, thanks a lot

@pankajtodkar 5 лет назад

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?

@maasaimaasai2895 5 лет назад

This is very clear man. very straight.

@Rebellionrider 5 лет назад

Thank you so much.

@AshishBurnwal 7 лет назад

You have really explained in very elegant way :) Thank you.

@akbaryuldoshev8983 8 лет назад

Thank u Manish for very informative series of videos

@Rebellionrider 8 лет назад

+Akbar Yuldoshev It's a huge pleasure that you find my videos helpful. Please do make sure to like and share with your friends.

@nikhilinamdar88 8 лет назад

nice explanation..happy :):)

@kirankumarjonnalagadda4767 7 лет назад

you are best tutor

@KamalenduRoy1984 7 лет назад

Thank you Manish

@sampsonite816 4 года назад

Why can't every tutorial be at this pace? Bravo

@sandeepjha5098 9 лет назад

Manish, can you post some tutorial on how to write procedures in Oracle ?

@smaug69 9 лет назад

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\pwd@instance 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 ?

@amitdubey3767 8 лет назад

Hi manish, could you please share the video for database refrsh incuding concept of refresh? Thanks,

@adeelmalik6002 4 года назад

sir gant access to HR user is necessary . cant we export using sys user ?

@yejiyou6123 7 лет назад

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

@AzeemKhan-yt4tm 5 лет назад

absolutely beautiful.

@Rebellionrider 5 лет назад

Thank you so much

@speedfightz23 9 лет назад

good tutorial

@juliosebastianmercadomarti3486 5 лет назад

Thanks

@amitbalyan3103 6 лет назад

is it for sql developer also

@nigamanandabindhani3688 9 лет назад

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

@hassanameerali6308 8 лет назад

Yo man good

@anudipray4492 Год назад

Can you create video for expdp and impdp for pluggable database only, as I am facing difficulty

@user-rp9fk3kc1p 2 года назад

it’s the same export dump file?

@phanninyeat7570 4 года назад

I got this message: Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS.UTL_FILE", line 536 ORA-29283: invalid file operation How to solve it?

@girjeshbajpai5404 4 года назад

I am getting below issue after running : expdp hybris63/hybris64@XE DIRECTORY=orcl_obj DUMPFILE=orclfull.dmp LOGFILE=full_exp.log FULL=YES; UDE-12545: operation generated ORACLE error 12545 ORA-12545: Connect failed because target host or object does not exist

@Hellopeople2334 8 лет назад

LRM-00105: 'YES;' is not a legal Boolean for 'full' Everything is as per the video but why this error is coming ?

@maradoxdkrypt296 4 года назад

Try putting FULL=YES after log in credentials

@kyatamkaran 7 лет назад

sir ji dba 2 ka RMAN,FLASHBACK, DATAGAURD PERFORMANCE TUNING bhi tutorial BANAO PLEASE BRO

@ayoob999 8 лет назад

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

@muhammadshoaibkhan2378 7 лет назад

Check the name of your global_variable by using the command: select * from global_name; and use it in place of orcl in hr/hr@orcl.

@anudipray4492 Год назад

Manish can you Make same video with pluggable database as i am getting error using expdp with pluggable database

@googissoftware 4 года назад

I got a TNS error : UDE-12170: operation generated ORACLE error 12170 ORA-12170: TNS:Connect timeout occurred To solve this, just remove the '@ORCL' part from the expdp (when working on the dbserver)

@VeerDahinwal 7 лет назад

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

@Auditoryy 2 года назад

same issue, how did you resolve it?

@ilhamhermawanzero7683 Год назад

how import please full

@seifibrahim4435 2 года назад

its says internal error

@saymainamdar7122 6 лет назад

C:\>expdp system/admin1234@XE DIRECTORY=sam DUMPFILE=xefull.dmp LOGFILE=samxe.log FULL=YES; LRM-00105: 'YES;' is not a legal Boolean for 'full' any idea?