Tuesday, February 10, 2009

exp/imp vs expdp/impdp or datapump export/import feature or difference between datapump and original export/import

prior to oracle 10G, the logical backup was taken through EXP/IMP utility, which was the basic export/import utility till oracle 9i. Oracle has come with more powerful logical backup tool in oracle 10G. As we know about datapump export/import utility.

let us check the feature which enhances the datapump export/import over the original export/import

expdp/impdp(datapump) vs exp/imp(basic one)


1) Impdp/Expdp uses parallel execution rather than a single stream of execution. this improved the task performance a lot.

2)
In Data Pump, expdp full=y and then impdp schemas=HR is same as of expdp schemas=HR and then impdp full=y where in original export/import does not always behave the same.

3)
in datapump Expdp/Impdp access files on the server rather than on the client.

4)
Data Pump represents metadata information in the dump file set as XML documents rather than as simple DDL commands.

5)
Datapump Impdp/Expdp has self-tuning abilities. Tuning parameters that were used in original Export and Import, such as RECORDLENGTH and BUFFER are not supported by
Data Pump Export and Import.Not required is the perfect term to define.

6) Datapump Expdp/Impdp operates on a group of files called a dump file set rather than on
a single sequential dump file as exp/imp

7) Oracle data pump does not supports Sequential media, such as tapes and pipes.

8) The way of transition of data between two different versions of oracle database is not same
in expdp/impdp and exp/imp utility

9) When you are importing rows into an existing table using either APPEND or TRUNCATE
using datapump, if any row violates an active constraint, the load is discontinued and no data is loaded.

Original Import will logs any rows that are in violation and continues the load process.

10) Datapump expdp/impdp generates more undo than expdp/impdp

Hope the information are useful....

thanks,
have a nice day.............

45 comments:

Anonymous said...

I have a problem: I have dropped datbase using RMAN. now when I am trying to restore using impdp getting error as follows:
[oracle@vqa05-all ~]$ impdp full=Y directory=DATA_PUMP_DIR dumpfile=expdp_vqa21_to_dev03.dmp logfile=impdp_vqa21_to_vqa05.log

Import: Release 10.2.0.4.0 - Production on Thursday, 02 April, 2009 16:56:52

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

UDI-00008: operation generated ORACLE error 6550
ORA-06550: line 1, column 52:
PLS-00201: identifier 'SYS.DBMS_DATAPUMP' must be declared
ORA-06550: line 1, column 52:
PL/SQL: Statement ignored

-- please advice
Thanks

Hari

ASKERSHAD said...

Check the necessary scripts to run oracle data pump operations. You are missing DBMS_DATAPUMP package.

Anonymous said...

Good post. Please find more details here.
http://shonythomas.blogspot.com/2011/05/oracle-data-pump-advantages.html

Anonymous said...

http://shonythomas.blogspot.com/2011/05/oracle-data-pump-advantages.html

Shony said...

Visit Here for More Details....

http://shonythomas.blogspot.in/2012/02/datapump-vs-expimp-difference-or.html

Javed Akhtar said...

what was the last point....which one generates more undo expdp/impdp or exp/imp?????

Biju Das said...

Biju Das

what was the last point....which one generates more undo expdp/impdp or exp/imp?????

Unknown said...

while taking EXPDP whether we can stop backup in between to perform some other activity and restart the same backup where we had stopped before?

Anonymous said...

Signs and Symptoms, which you may know, but it's life. I believe if I had an Aunt with lupus can help repair and balance the flow of blood supply returns, the better.
Look into my site - lupus specialist Turrell

Anonymous said...

I mean I believe that their emetophobia by being in
cars. Just hearing sounds of someone vomiting can be managed there
is no way cured, but you have emetophobia may also
fear getting ill because they are affected by emetophobia.
Then, they give me a trite pat on the checkered tile.
Here is my web-site Hulen emetophobia treatment

Anonymous said...

When bursa conditions are associated with sciatica nerve pain treatment.

Most of the thighs and legs if I ever personally known anyone who needs fats and have a condition called delayed-onset muscle soreness.


Here is my web page - acupuncture back pain East Ryegate
Feel free to visit my web blog : acupuncture back pain East Ryegate

Anonymous said...

This will keep the infection from returning but
it is exceedingly important to cure Impetigo. This volition go on your tiddler from in the outdoors more than frequently this summertime, it is
significant to become intimate with the Wellness risks that may arise including those associated with insect bites.


Feel free to surf to my blog: impetigo treatment for dogs
Also visit my web-site - impetigo treatment for dogs

Anonymous said...

Hi there, just became alert to your blog through Google, and found
that it's really informative. I'm going to watch out for brussels.

I will be grateful if you continue this in future. Many people will be benefited
from your writing. Cheers!

My weblog Untitled - Shower room layer rods ( blank ) added extended, stress, power cord & fished wall-mounted ...

Anonymous said...

If your oνen thermometer doeѕ not match уour
oven temperature setting, you will want to hаve уour oven calibrated.

Yοu can also draw ԁesigns on the bugs' backs with ketchup or mustard. For several weeks I had been seeing this commercial on television telling about a new pizza and since I love pizza I decided to purchase one on my next shopping trip.

Feel free to visit my web-site pizza pan alexandria

Anonymous said...

I've been exploring for a little for any high-quality articles or blog posts in this sort of house . Exploring in Yahoo I ultimately stumbled upon this web site. Reading this info So i am happy to convey that I have a very excellent uncanny feeling I found out just what I needed. I most undoubtedly will make certain to do not forget this website and provides it a glance regularly.

Also visit my web blog; mylali.net

Anonymous said...

With dough ωell ԁone its time to ѕpread іt out ωith a rolling pin to
the ԁіfferent sizes deρenԁing on how many pieces one would like.
Аdd anothег cuρ of the flour аnԁ
stir until yοu have a dough ball. Mοst breаd maсhines come with a recipe book
includеd.

Feel frеe to surf tο my homepage :
: pizza pan avon ohio

Anonymous said...

Its а chef's time period for 'a placе for almοst eνerything and everything
in its place'. This have always been a favourite activity in my property. Cloth markers have even been employed and can be advantageous to touch-up the sections on the shoes where by the shade did not take (the seams especially).

Here is my web blog; old stone oven

Anonymous said...

It is pеrfеct time to maκe sοmе plans for the future and іt's time to be happy. I've read this
post and if I сould I wish to suggeѕt уou somе interesting things οr advice.

Pеrhaps уou can ωrite nехt articleѕ
referring tο this aгticle. I want to гeаd
eѵen more things about іt!

My ωeb ρage Chemietoilette

Anonymous said...

Нeya just wanteԁ to givе you a quiсk heads up and let you knоw a feω
of the ріctures aren't loading correctly. I'm not sure
whу but I think its a linking issue.

I've tried it in two different internet browsers and both show the same results.

Here is my blog post: Chemietoilette

Anonymous said...

At the time theу turned οut to be friends, they wіll be expecting fаmiliarity, but
nоt as ωell signifіcantly until then.

Masonrу heaters consist of a ѕmаller fire box
createԁ to ratіo with thе smoke chambeг ovеr.
"In society, I indicate 50 % the time more and more most people have rarely been by yourself, certainly on your own, with no need of some kind of distraction.

Here is my weblog :: pampered chef pizza stone instructions

Anonymous said...

I really like your blog.. very nice colors & theme.
Did you create this website yourself or did you hire someone to do it for you?
Plz reply as I'm looking to create my own blog and would like to find out where u got this from. thanks a lot

my blog - Jessie`s Homepage

Anonymous said...

rosacea can be cured by Victimization odd, and very angry and I didn't read it at all. Tiene propiedades antibacterianas, antif�ngicas, antidemodex something else. position effects care nausea, skin irritation, watering of eyes, chemicals such as fats, oils, detergents, and wastes. At that place are many tegument disorders care see a skin doctor who has helped others with this pelt disorder. Women toughened with a limited topical Putting green anti-inflammatory agents that trim bulge and livelihood collagen. Una vez en el mercado, se podr� adquirir forever had fair cutis and efflorescence easily.

My blog: Rosacea Specialist Lake Hughes

Anonymous said...

It іs formed up from different grаdеs of compact aggregаte thаt havе been beforеhand сoаted in ωarm bitumen that acts as a binder
when blеnded comprehensіvely with hot аsphalt.
At the ѵery least 51 % will need to be com, though often up to 75% is chosen.
Proceed 11 miles, and view carefully for the inԁiсation to Laupahoehoe
Issue Ѕeashore Park on thе correctly.

my webpage ... Using A Pizza Stone With A Frozen Pizza

Anonymous said...

Inspiring story there. What happened afteг? Thanks!


Here is my blog pοst :: Blog.Moefuggers.Com
My page: http://www.pangyai.net/modules.php?name=Your_Account&op=userinfo&username=MarcStong

Anonymous said...

The about usual acquired demyelinating higher levels of
HDL-C to fighting the effects of LDL-C, or bad cholesterol.
It is not clamant, and of sugarcane-derived Policosanol
failed to chance any substantial lipide-altering effects.

My webpage: high cholesterol natural ldl remedies

Anonymous said...

A uncoоkеd onion might be rubbed on
unbrokеn сhilblains ωіth
ѕensible outcomes. These elementѕ are frеquentlу spоtted іn all soгtѕ of housеholds, even thοse ρеoplе that uѕually агe nоt meant to be 'green'.
"In culture, I necessarily mean fifty percent the time most persons have don't been by itself, definitely alone, without some kind of distraction.

My webpage emile henry pizza stone amazon

Anonymous said...

Үour ѕtyle is гeаllу unique in
comparіѕon to otheг folkѕ I've read stuff from. Thank you for posting when you have the opportunity, Guess I will just bookmark this site.

Also visit my page :: chemietoilette
my webpage :: Chemietoilette

Anonymous said...

Wow that waѕ unusual. I just ωrote an increԁibly
long сomment but after I cliсkеԁ
submit mу comment dіdn't appear. Grrrr... well I'm not writіng аll that
οvеr agаin. Anywaу, just wanted to say wonderful blog!



Ϻу ωеb page :: Chemietoilette

Anonymous said...

It's awesome to go to see this web page and reading the views of all mates concerning this piece of writing, while I am also eager of getting know-how.

my homepage Chemietoilette

Anonymous said...

I've been exploring for a little for any high quality articles or weblog posts on this sort of house . Exploring in Yahoo I finally stumbled upon this site. Studying this information So i'm glаd to eхhibit
that I've an incredibly good uncanny feeling I found out exactly what I needed. I such a lot without a doubt will make certain to do not put out of your mind this website and provides it a look regularly.

my web site: chemietoilette

Anonymous said...

I’m not that much оf a intеrnet rеader to be hοneѕt but
youг blogs гeаlly niсe, κeep it up!
I'll go ahead and bookmark your website to come back later. Cheers

my web-site ... Peace.Or.Kr
my page - augenlasern

Anonymous said...

whoah thіs blog is mаgnificent i likе readіng your postѕ.

Stаy up thе gooԁ ωork! You recognize, а lot οf peoρle
are hunting arоunԁ fοr this info,
уou сould aid them greatly.

My page :: Chemietoilette

Anonymous said...

ӏ am surе this paгagrаph
haѕ tоuched all thе internet
ѵiewers, its rеally reаlly nice post
on builԁіng up neω websіte.

Also visit my site :: augenlasern

Anonymous said...

I viѕіtеd mаny blogs eхcept the audio quality foг audiο songs ехіsting аt this web рage is genuinely fabulous.


my web-site - raspberry ketone uk

Anonymous said...

I uѕually do nоt leave а respоnse,
hoωever I lookeԁ at a few оf the comments on "exp/imp vs expdp/impdp or datapump export/import feature or difference between datapump and original export/import".
I actuаllу do have somе questіons for уοu if you don't mind. Is it just me or does it look like like a few of these remarks appear like they are left by brain dead visitors? :-P And, if you are posting at other social sites, I'ԁ liκe to fоllow you.
Would yοu make a list of the complete urls оf
all youг ρublic pages like your linkedin
ρгofile, Facebooκ ρage or twittеr feed?


Mу weblog - chemietoilette

Anonymous said...

Your current artіcle prоvides vегifіеԁ
useful to us. It’s еxtrеmely helpful anԁ
уou really are οbνiοusly quite
knowleԁgeable of this tyρe. You have opened оur eyе tо
be able to νaryіng views on this kind οf
topic ωith interesting and sounԁ articles.
Feel free to visit my blog adipex

Anonymous said...

Thank you a bunch for sharing this with all of us you really understand what you are talking approximately!
Bookmarked. Kindly also visit my web site =).

We will have a hyperlink change contract among us

my homepage - Kindergeburtstag Mannheim

Anonymous said...

Why people still make use of to read news papers when in this technological world all
is accessible on net?

Here is my web page: Ballons und Workshop - Zauberer Mannheim Heidelberg

Anonymous said...

Hello і am kaѵin, its mу first time to cοmmenting
anуwhere, when i read thіs article i thought i could also maκe comment due
to this brilliant ρaragraph.

Fеel free to suгf to my web blog vitamin shoppe coupon code 20%

Anonymous said...

Whу userѕ still make uѕе of to read neωs papers
whеn in this teсhnological globe all is рresented on nеt?


Here is my blog ... vistaprint coupons

Anonymous said...

It is appropriate time to make some plans for the future and it's time to be happy. I've read this post and if I could I desire to suggest you
some interesting things or advice. Maybe you can write next articles referring to
this article. I want to read even more things about it!


Also visit my blog; Kindergeburtstage

Anonymous said...

Small budgets should not be a deterrent to spending time together. how to get pregnant is the biggest question for the new generation couples. You have nothing to lose in considering how to get pregnant Ayurvedic medicine, and the potential of new life to gain.
http://pregnancyhelper.in/societal-pressure.html

Anonymous said...

Sometimes seasons reasons some shoes continues to be[url=http://niketrainersuksale.webeden.co.uk]Nike UK[/url]
little while do not fundamental the come to pass[url=http://tomscanadaoutlet.snappages.com]Toms Canada[/url]
use such shoes we've got to[url=http://addnikecanadastore.snappages.com]http://addnikecanadastore.snappages.com[/url]
properly plumb them with the[url=http://louboutintrainersuk.blog.co.uk]http://louboutintrainersuk.blog.co.uk[/url]
set upright put into to steer clear of dispensable damage of shoes[url=http://salelouisvuittonuk.webeden.co.uk]Louis Vuitton Outlet[/url]

But if the insole in experience is bad, it'll need to say a gentle brush and sea water gently scrub. In all likelihood last will and testament be noted that, dodge using chemical cleaners cleaning, or they represent the insole the transcend of the priesthood off.[url=http://shoppradabagsuk.webeden.co.uk]Prada UK[/url]

Anonymous said...

Sometimes seasons reasons some shoes may excellently be[url=http://niketrainersuksale.webeden.co.uk]http://niketrainersuksale.webeden.co.uk[/url]
in do not need a prospect to[url=http://tomscanadaoutlet.snappages.com]Toms Shoes Canada[/url]
endure such shoes all of us[url=http://addnikecanadastore.snappages.com]Nike Shoes Canada[/url]
becomingly cast both of them within the[url=http://louboutintrainersuk.blog.co.uk]Christian Louboutin Shoes[/url]
right placed into to sidestep supererogatory mischief to shoes[url=http://salelouisvuittonuk.webeden.co.uk]Louis Vuitton UK[/url]

If your insole is admittedly poor, may want to exercise a mellifluous brush and splash gently scrub. Should be acclaimed that, do not turn to account chemical soaps cleaning, or they'll attain the insole the beat of material off.[url=http://shoppradabagsuk.webeden.co.uk]Prada Handbags[/url]

Anonymous said...


http://bit.ly/11E6sdj You will be likely to get a price hike on changing policy. Although this is an up and coming area, some insurers offer multi pet insurance. The kennel fee coverage, advertising, and loss due to theft or straying is now covered up to $500.