Oracle Data Pump | Perform faster data export and import in Oracle

[@MuthuKumar-hx4to]

sir, I have no words to appreciate you. clear explanation. you will be the main reason once I am placed on the job. I need your support forever. thank you so much

[@dbagenesis]

You are most welcome :)

[@alejandroduarte2143]

after a long time searching for a good explanation, I finally found this video. Congratulations and thank you very much for sharing!

[@sonugowda-kj3oi]

Arun Sir Literally you have excellent teaching skills, the way you explain the concepts really it is awesome, 6 months back I have reffered your backup and recovery concepts videos especially you have made videos on RMAN so using that i have given seminar on RMAN topic my manager appreciated me infront of my seniors so thanks a lot for your videos!!!, Keep up the good work!!!.

[@mahmudurkhan5754]

Your video quality is excellent sir, Please keep continue

[@dharanic1075]

Whatta teaching skills you have, you made us to clear understanding well with practical lab exercise ❤

[@dbagenesis]

Glad it was helpful!

[@bandaruvasu2527]

The way of your explanation is exellent.

[@dbagenesis]

Glad it helped

[@mahfujalam903]

Dear sir, My fulldatbase export size is around 600gb . Import is taking longer time . How to speedup the import process .

[@DarioPudlo]

Still missing the compressed dumps, without having to pay for those options.

[@funny-y6t4s]

Sir Any idea how to resolve this..getting following error while expdp or impdp in oracle 11g .. i tried increase stream pool UDE-31623: operation generated ORACLE error 31623 ORA-31623: a job is not attached to this session via the specified handle ORA-06512: at "SYS.DBMS_DATAPUMP", line 2862 ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052 ORA-06512: at line 1

[@ariaseraj4005]

Clean explanation. Great job.

[@dbagenesis]

Glad it was helpful!

[@sameerahmad7592]

Hi brother, kindly let me know you are performing all the operation on Linux OS having Oracle installed on it....? Since I'm having just the opp Windows Installed having Oracle on it & Unix installed on Windows on a VW Ware.

[@sureshkrish07]

Hi All, is there any option to manage the export/import without Linux level access.. Can you help on this..

[@dbagenesis]

You post question on www.forum.dbagenesis.com/

[@robotikanet6279]

If I want to make a schema import from a table space to a different table space then I use the last command except I skip the TABLES parameter?

[@alessandresilva4490]

Very good explanation congratulations

[@dbagenesis]

Thank you!

[@sudheerbella8697]

in schema level we need to remap tablespace aswell if we are using different from prod to preprod

[@abdulwahid-qq4dx]

hi i have installed oracle 19c on my localhost linux server, created a user name test_abc and also created two dummy table in this user. export data into a directory as per your tutorial that i following. Now i have created another user named IMPORT_USER in the same pdb database. whenever i run the import commant impdp directory=PDB_EXPDIR dumpfile=SCOTTAA.dmp logfile=expdpSCOTTAA.log remap_schema='TEST_ABC:IMPORT_USER' I face following errors Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39087: directory name PDB_EXPDIR is invalid Please guide if possible. Thanks in advance

[@adelfoka1546]

Is it a must for the directory name to not be the same in both servers?

[@bk5268]

Sir how i join ur live class and ur mentorship guidance for leanr oralce dba , rac , dataguard

[@ponmarimuthus8772]

Can we use data pump to export in different file format like csv ?

[@noorhirjee2274]

Resumable error: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP1. Please help us. THANKS

[@PGExcellenceClasseswecan]

kindly increase temp space or first chk which query is taking more temp

[@nparoroport5117]

sir i exported a table from the database to a dumpfile on the command prompt export was successfull but looking at the log message under type it says crash dumpfile instead of dumpfile. i used windows 10 operating system. what could have caused this?

[@noorhirjee2274]

can datapump , import and export utilities be done on same server? THANKS

[@pradeeptiwary2131]

Sir can you provide playlist to learn oracle administration sequentially atleast the videos which you already uploaded

[@vamsikrishna-rs7iz]

sir if there are indexes and partitions present in the source table then does the target table contains it

[@dbagenesis]

Not necessarily !

[@tuffan479]

Can we export Rac datapump ASM filesystem file to standalone database???

[@dbagenesis]

Yes, its like you are exporting SQL statements like CREATE TABLE, INSERT INTO TABLE etc...

[@amitshinde9724]

please ,also make video for RAC export and import with maximum useful parameters

[@dbagenesis]

Sure!

[@kishorekumar-vs4pu]

Super... Very useful one🔥💯

[@dbagenesis]

Glad to hear that

[@dreamvallyhasan4807]

Love from bottom of my ♥

[@dbagenesis]

Thank you Keep watching!

[@sudheerbella8697]

import will work we use different location in preprod server

[@sonugowda-kj3oi]

sir if possible please make videos on how to install oracle 19c on linux and how to configure.

[@shreyagirish7617]

Hi Sir, nice explanation. Thanks. Can u please let me know what query I need to use while importing after I take row level export

[@dbagenesis]

No special command. Just use the same command that you use for table level import.

[@VMI33]

how would you import the row? would you ad the "query=" as well?

[@VMI33]

and who would you grant read, write to if no one else was to do the exp/imp, but you as the dba...thank you.

[@BHARAT_PRODCAST]

yes

[@chandramunagala2040]

Hi Sir, nice explanation. I would like know how to export the user,usertables,tablespaces,schemas by using single export command. Can you give me a suggestion.

[@dbagenesis]

We can not in single export command. Tablespace export we need to take separate and on target we need to create tbs first and import schema.

[@swagwalachintu4660]

sir agr mere pas 2 database hain db1 or db2 mene db1 ka all data export karlia ab me db1 ka all data db2 me import karna hy tw uske lia hm kia commond likhyen gyen??? or kon kon c privilages dyen gyen??? plz guide me

[@dbagenesis]

www.support.dbagenesis.com/post/oracle-data-pump-expdp-impdp#viewer-d5kr2

[@swagwalachintu4660]

@@dbagenesis thanks

[@teme4573657]

which approach is best to move incremental data from source DB to Oracle Datawarehouse?

[@dbagenesis]

I assume you mean to say how can I copy the backup pieces from one DB to another! SCP, if backup pieces are small Mount the storage (which contains backup pieces) on both servers simultaneously. Last option, ask storage team to copy files for you ;)

[@challakoti707]

Tq so much sir . I am learning db in your class ... Sir please respond mee ....

[@ashokraj2282]

nice explanation.thanq

[@fakrudeenali2005]

Can I have RAC course?

[@dbagenesis]

Sure: dbagenesis.com/p/oracle-rac-beginners

[@Agunu]

Great explanation sir I really appreciate your service to the society Sir I tried to export a table from my hr using export utility It says Ora-39070:unable to open the log file. Ora-39087:directory name datapump is invalid. I need help sir Thanks

[@dbagenesis]

Make sure the dump directory is listed under DBA_DIRECTORIES and it has enough space!

[@niksenjoy]

u need to create this "datapump" directory at os as well as db level with read & write access.

[@zabeehfarooqui]

awesome

[@dn9416]

Thnx