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

#Oracle Data Pump is a newer, faster and more flexible alternative to the "exp" and "imp" #utilities used in previous Oracle versions. In addition to basic #import and #export functionality #data #pump provides a PL/SQL API and support for external tables.

00:00 Oracle Data Pump
02:16 Data Pump Export
02:38 Data Pump Import
03:37 Data Pump Directory
07:08 Create Directory at OS level
07:44 Create Directory at Database level
08:29 Grant permission on Directory
09:35 View directory information
12:44 Performing Data Pump Export
12:55 Invoke Data Pump Export Utility
14:18 Take Database level Export
15:59 Take schema level Export
18:37 Take Table level Export
20:10 Take Row level Export
21:13 Performing Data Pump Import
21:21 Know options of Data Pump Import
21:44 Import all database
23:55 Import Schema
29:13 Import a Table
30:10 Import a Table to another user
30:22 Import a Table to another Tablespace

[MuthuKumar-hxto]

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

[sonugowda-kjoi]

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!!!.

[alejandroduarte]

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

[dharanic]

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

[mahmudurkhan]

Your video quality is excellent sir, Please keep continue

[bandaruvasu]

The way of your explanation is exellent.

[mahfujalam]

Dear sir,

My fulldatbase export size is around 600gb . Import is taking longer time .

How to speedup the import process .

[sameerahmad]

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.

[DarioPudlo]

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

[bk]

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

[sureshkrish]

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

[funny-yts]

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

[noorhirjee]

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

[adelfoka]

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

[shreyagirish]

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

[pradeeptiwary]

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

[ponmarimuthus]

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

[chandramunagala]

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.

[robotikanet]

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?

[sudheerbella]

import will work we use different location in preprod server