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

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ธ.ค. 2024
  • 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...
    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.co...
    / 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

ความคิดเห็น • 70

  • @rameshthamizhselvan2458
    @rameshthamizhselvan2458 7 ปีที่แล้ว +5

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

  • @SATORvii
    @SATORvii 6 ปีที่แล้ว

    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!

  • @HarrisMwika
    @HarrisMwika 5 หลายเดือนก่อน

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

  • @otip3604
    @otip3604 10 หลายเดือนก่อน

    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.

  • @theans786
    @theans786 7 ปีที่แล้ว

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

  • @ZainabSaleh85
    @ZainabSaleh85 6 ปีที่แล้ว

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

  •  8 ปีที่แล้ว +1

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

    • @Rebellionrider
      @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

  • @maasaimaasai2895
    @maasaimaasai2895 5 ปีที่แล้ว +1

    This is very clear man. very straight.

  • @vidmayur
    @vidmayur 9 ปีที่แล้ว +1

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

  • @akbaryuldoshev8983
    @akbaryuldoshev8983 8 ปีที่แล้ว +1

    Thank u Manish for very informative series of videos

    • @Rebellionrider
      @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.

  • @stevemasinde7207
    @stevemasinde7207 7 ปีที่แล้ว

    Thanks, Started following your tutorials

  • @blueboy334
    @blueboy334 7 ปีที่แล้ว

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

  • @vongsiloryongpao6026
    @vongsiloryongpao6026 3 ปีที่แล้ว

    Loved it !!! Thanks for sharing ...

  • @sampsonite816
    @sampsonite816 5 ปีที่แล้ว +1

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

  • @LichaelJohn
    @LichaelJohn 2 หลายเดือนก่อน

    Big help. Thanks!

  • @AshishBurnwal
    @AshishBurnwal 8 ปีที่แล้ว

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

  • @kimrasmey4568
    @kimrasmey4568 10 ปีที่แล้ว

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

  • @ReemAlissa
    @ReemAlissa 8 ปีที่แล้ว

    thank you very much that was very helpfull

  • @kirankumarjonnalagadda4767
    @kirankumarjonnalagadda4767 7 ปีที่แล้ว

    you are best tutor

  • @SanjeetKumar-ch4wq
    @SanjeetKumar-ch4wq 8 ปีที่แล้ว

    You are gem, my dear friend, thanks a lot

  • @pankajtodkar
    @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?

  • @mgc30
    @mgc30 7 ปีที่แล้ว

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

  • @mohankrishna3635
    @mohankrishna3635 4 หลายเดือนก่อน

    Useful tutorial

    • @Rebellionrider
      @Rebellionrider  4 หลายเดือนก่อน

      I'm glad you found it useful! If you could quickly master any advanced SQL skill, what would it be and why? 😊

  • @sandeepjha5098
    @sandeepjha5098 10 ปีที่แล้ว +2

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

  • @amitdubey3767
    @amitdubey3767 8 ปีที่แล้ว +1

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

  • @AzeemKhan-yt4tm
    @AzeemKhan-yt4tm 5 ปีที่แล้ว +1

    absolutely beautiful.

  • @nikhilinamdar88
    @nikhilinamdar88 9 ปีที่แล้ว

    nice explanation..happy :):)

  • @KamalenduRoy1984
    @KamalenduRoy1984 7 ปีที่แล้ว

    Thank you Manish

  • @shubhamkapade2967
    @shubhamkapade2967 4 หลายเดือนก่อน

    Hi Manish.
    Who provide the memory for exp and imp? If any bg process then let me know.

    • @sudaisshenoo
      @sudaisshenoo หลายเดือนก่อน

      SGA Provide

  • @anudipray4492
    @anudipray4492 ปีที่แล้ว

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

  • @nigamanandabindhani3688
    @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

  • @adeelmalik6002
    @adeelmalik6002 5 ปีที่แล้ว

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

  • @yejiyou6123
    @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

  • @smaug69
    @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 ?

  • @speedfightz23
    @speedfightz23 10 ปีที่แล้ว

    good tutorial

  • @user-rp9fk3kc1p
    @user-rp9fk3kc1p 2 ปีที่แล้ว

    it’s the same export dump file?

  • @juliosebastianmercadomarti3486
    @juliosebastianmercadomarti3486 6 ปีที่แล้ว

    Thanks

  • @anudipray4492
    @anudipray4492 ปีที่แล้ว

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

  • @phanninyeat7570
    @phanninyeat7570 5 ปีที่แล้ว

    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?

  • @amitbalyan3103
    @amitbalyan3103 7 ปีที่แล้ว

    is it for sql developer also

  • @VeerDahinwal
    @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
      @Auditoryy 2 ปีที่แล้ว

      same issue, how did you resolve it?

  • @ayoob999
    @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
      @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.

  • @girjeshbajpai5404
    @girjeshbajpai5404 5 ปีที่แล้ว

    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

  • @kyatamkaran
    @kyatamkaran 7 ปีที่แล้ว

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

  • @hassanameerali6308
    @hassanameerali6308 8 ปีที่แล้ว

    Yo man good

  • @Hellopeople2334
    @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
      @maradoxdkrypt296 5 ปีที่แล้ว +1

      Try putting FULL=YES after log in credentials

  • @googissoftware
    @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)

  • @saymainamdar7122
    @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?

    • @PraveenRajKumarYx
      @PraveenRajKumarYx 6 ปีที่แล้ว

      I'm facing the same problem as like Sayma. @Manish, could you please help us here? Thanks in advance!

    • @fabiodominguezz
      @fabiodominguezz 6 ปีที่แล้ว +3

      try C:\>expdp user/password@host/servicename full=Y DIRECTORY=orcl_full DUMPFILE=orclfull.dmp LOGFILE=full_exp.log;

  • @ilhamhermawanzero7683
    @ilhamhermawanzero7683 ปีที่แล้ว

    how import please full

  • @seifibrahim4435
    @seifibrahim4435 2 ปีที่แล้ว

    its says internal error

  • @michaelramirez7693
    @michaelramirez7693 5 ปีที่แล้ว

    good tutorial,
    I have this inconvenience "ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS"

  • @shreyanshichauhan1636
    @shreyanshichauhan1636 3 ปีที่แล้ว +1

    Import video.

    • @vrajk3955
      @vrajk3955 3 ปีที่แล้ว

      Yes pls do make 'em ...need whole db refresh video,if possible.

  • @aymanalsapagh1236
    @aymanalsapagh1236 10 ปีที่แล้ว +2

    (y)

    • @Rebellionrider
      @Rebellionrider  10 ปีที่แล้ว

      ayman alsayed Thanks for the thumbs up :-) hope you are enjoying my videos. Your feedback means a lot to me.

    • @aymanalsapagh1236
      @aymanalsapagh1236 10 ปีที่แล้ว +1

      Manish Sharma and i'm so happy following u