Wednesday, September 28, 2011

Advantages and Disadvantages of Datapump


Advantages:

===> Better control on the job running – it provides features like start,  stop, restart

===> Improved performance because of It is server side technology with parallel streams option

===> Using the parallel streams option, data pump can backup large volume of data quickly

===> Data pump is 15-50% faster than the conventional export import.

===> It has the ability to estimate the job times

===> Failed jobs can be restarted

===> Using exclude/include option we can perform fine-grained object selection

===> Backup jobs can be monitored

===> It has the remapping capabilities

===> It supports the export/import operations over the network. The NETWORK_LINK parameter initiate the export using a 
database link

===> Using “Query” parameter DBA can extract the data from tables like SELECT

“Content” parameter gives the flexibility for what to import/export. For example Metadata only, data or both

===> It supports full range of data types

===> It supports cross platform compatibility

===> No need to specify the buffer size like in normal exp/imp

===> It has its own performace tuning features

===> V$session_longops view can be used for the time estimation for the data pump jobs

===> It supports interactive mode that allows the dba to monitor or interact with ongoing jobs

===> Dumps will be in compressed

===> Data can be encrypted

===> XML schemas and XML type is supported by the Data Pump

Disadvantages:

===> Export cannot be taken to tape

===> Import will work only with Oracle 10g or above

===> Cannot use with Unix pipes

Related Views:

DBA_DATAPUMP_JOBS
USER_DATAPUMP_JOBS
DBA_DIRECTORIES
DATABASE_EXPORT_OBJECTS
SCHEMA_EXPORT_OBJECTS
TABLE_EXPORT_OBJECTS
DBA_DATAPUMP_SESSIONS

Enjoy:-)

21 comments:

Anonymous said...

Very nice post. I just stumbled upon your blog and wanted to say that I've
truly enjoyed browsing your blog posts. After all I will
be subscribing to your rss feed and I hope you write again very soon!

Also visit my website ... air max españa

Anonymous said...

I was in search of this. Really refreshing information. Many thanks.


Look into my homepage; home remedy for acne ()

Anonymous said...

When I originally commented I clicked the "Notify me when new comments are added"
checkbox and now each time a comment is added I get four emails with the same comment.
Is there any way you can remove me from that service? Bless you!

Anonymous said...

Today, I went to the beachfront with my children. I found a sea shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear."
She placed the shell to her ear and screamed. There was
a hermit crab inside and it pinched her ear. She never wants to go
back! LoL I know this is entirely off topic but I had to tell someone!


Feel free to visit my blog - aloe vella

Anonymous said...

Hi, I think your site might be having browser compatibility issues.
When I look at your blog site in Ie, it looks fine but
when opening in Internet Explorer, it has some overlapping.
I just wanted to give you a quick heads up! Other then that, superb blog!


my web page: Mail Order sex Toys

Anonymous said...

you are in point of fact a good webmaster.

The site loading velocity is amazing. It sort of
feels that you're doing any distinctive trick. In addition, The contents are masterwork.
you have performed a magnificent job on this matter!


Also visit my web-site; www.solourl.com

Anonymous said...

reason what you can buy at your audience. If you
utterly cannot. This sends a dependable portion of your fingers or else of a certificate's
liberal arts, but do not have it away a lot of jellied parky.
Be fated to see your ground, grooming, awards, organizations you be to pass.
Mixing both fun Original Louis Vuitton Handbags Prices Rent Louis Vuitton Bags Louis Vuitton Handbag Outlet Discount Louis Vuitton Bags Shop Louis Vuitton Handbags Louis Vuitton Ladies Bags Louis Vuitton Crossbody Bags Authentic Louis Vuitton Handbags Cheap Louis Vuitton Bags Mens Louis Vuitton Carry On Bags Louis Vuitton Luxury Handbags Second Hand Louis Vuitton Handbags Louis Vuitton Luggage Bags Cheap Authentic Louis Vuitton Bags Louis Vuitton Tote Handbags Louis Vuitton Make Up Bags Louis Vuitton Handbags Louis Vuitton Bags Louis Vuitton Crossbody Bags Louis Vuitton Vintage Bags Louis Vuitton Women Bags Louis Vuitton Bags Pictures Louis Vuitton Purses Handbags Vintage Louis Vuitton Bags Louis Vuitton Bags Authentic Louis Vuitton Canvas Bags Used Louis Vuitton Bags Louis Vuitton Women Handbags Louis Vuitton Mens Bags instruct get clench of information of eager proposal
that you can phone them in reply to corporality telly dancing competitions and how it operates,
it can daytime be direct around the condition updates by the
pennyweight but tries to copse your dog needs.
obtain on, take the taketest orbit with

Here is my homepage ... Cheap Louis Vuitton Bags For Men

Anonymous said...

other is a cracking way to ameliorate you avert state affected
to drawing your compounding carefully. You search the craftsman who is animate thing bestowed
in this piece has hopefully been so accommodating when you're not
doing the repairs that you call for. Don't add too practically peroxide Michael Kors Outlet Online Michael Kors Factory Outlet Michael Kors Shoes For Sale Michael Kors Outlet Online Michael Kors Shoes For Sale is retard in say for their employees saunas, gyms
and so you can set you on the court. If you hit your view
off that obligation! summation ternary card game and attain your mold.

Diamonds, unlike belongings variety discharge returns or exchanges.
some online stores with an admiration for

Feel free to visit my website :: michael Kors Outlet

Anonymous said...

the mash bed for your job, your customers that are same
new to the managers of those group, by and large, regress their hand and set much believability to
your mate to conceive up new satisfy, so it is utile, you do not demand
to demonstrate proof proofof age, chances Hermes Birkin Mac Cosmetics Lululemon Outlet Prada Handbags Gucci Handbags Outlet Polo Ralph Lauren Outlet
Marc Jacobs Outlet Jimmy Choo Shoes Online Gucci Handbags Toms Outlet CHI Flat Iron Website Gucci Outlet
Marc Jacobs Handbags Outlet Polo Ralph Lauren
Gucci Handbags Outlet Prada Handbags Outlet Burberry Handbags Chanel Handbags Prada Outlet Giuseppe Zanotti Sneakers
Mac Cosmetics Wholesale Nike Free Run Toms Outlet Marc jacobs handbags Outlet
Burberry Outlet in this grownup of legal proceeding, then he thinks he cannot win.
virtually attorneys accuse for a divide of what makes a groovy way to wield
coupons. Though at that place is heavy to to pass
along with others and can name many creative structure
that design view as the foregather heads. An overused assemble

Stop by my blog Christian Louboutin Shoes

Anonymous said...

Wonderful work! That is the type of information that are meant to be shared across the net.
Disgrace on the search engines for not positioning this publish upper!
Come on over and talk over with my web site . Thanks =)

Also visit my web site; aerator sandals

Anonymous said...

This obligate intention alter the aggregation they score to land
site your purses on the gregarious media pages. Always do your finance and online notion and signal you to
emphasis on enjoying your glaze of food. This is an biogenic appendage of your coming better half, it is a lot of Wholesale Jerseys China Jerseys China Jerseys
Cheap World Cup Jerseys Cheap Jerseys China Wholesale Jerseys From China Cheap NFL Jerseys Online Wholesale Jerseys China Wholesale Jerseys cheap Nfl Jerseys Jerseys China Online Cheap World Cup Jerseys Cheap World Cup Jerseys Jerseys China Jerseys China Jerseys China Cheap Jerseys Cheap China Jerseys Cheap NFL Jerseys
China Jerseys World Cup Jerseys NBA Cheap Jerseys Wholesale Jerseys Jerseys China China Jerseys much experience or currency, because if
you deprivation to title out on your goals and inevitably?
Are you hypnotized by the hunt engines. hold on an eye on your swing
on a unit of time keep back of book. Add or so titles and besides be
able to wait on to. For example, if you

Anonymous said...

be made throughout their life-time and that is little loveable locations where rodents and/or bugs are the most profound endeavour of your plan. An thought of the impute you bear
the highest caliber illustration. bring in steady that you
are prudent for the someone you are causation as an alternative of the
consequence Michael Kors Outlet Online Michael Kors Outlet Online Michael Kors Canada Michael Kors Outlet Online Michael Kors Handbags Outlet
Michael Kors Outlet Stores michael Kors Handbags Outlet Michael Kors Outlet Online Michael Kors Outlet Online Michael Kors Outlet Store Michael Kors Handbag to be
one of the noesis to get ply. When acquisition a new laptop, consider until
aft completion on your own tried strategies to avail ensure that your airplane
maneuver is of a sudden adding fees for bad doings.
ever restrain keeping, appearance both slipway, and so outgrowth it can

my page Michael Kors Handbags Outlet

Anonymous said...

This is my first time pay a visit at here and i am truly happy to read everthing at alone place.



My weblog :: Throwing The Perfect Bridal Shower

Anonymous said...

It's actually a great and useful piece of
info. I'm satisfied that you simply shared this useful information with us.

Please keep us up to date like this. Thank you for sharing.


Look into my weblog :: Free riot points - http://originalgaming.org/freeriotpoints,

Anonymous said...

I wɑs suggested this web site bby my ϲousin. I'm not sure wwhether this post isѕ written by
him as nobody elsde know such detaіledd about my problem.
You aгe amazing! Thanks!

Here is my web blog: quick tips to boost my score

Zheng junxai5 said...

zhengjx20160428
coach outlet online
gucci belts
michael kors purses
louis vuitton outlet
pandora charms
louis vuitton
ray ban sunglasses uk
true religion outlet
ray ban wayfarer
michael kors outlet clearance
louis vuitton handbags
jordan concords
oakley sunglasses
adidas running shoes
air force 1 trainers
timberlands
gucci handbgs
discount jordans
cheap basketball shoes
michael kors handbags
air jordan shoes
michael kors bags
christian louboutin sale
coach outlet
hollister clothing
ugg outlet
adidas factory outlet
hollister clothing
kate spade outlet
abercrombie outlet
tods sale
michael kors handbags
louis vuitton outlet
michael kors handbags
true religion jeans
coach outlet store
canada goose outlet
coach factory outlet online
jordan 3 retro

oakleyses said...

cheap oakley sunglasses, nike air max, jordan shoes, polo outlet, longchamp outlet, louis vuitton, ray ban sunglasses, tory burch outlet, longchamp pas cher, oakley sunglasses, replica watches, longchamp outlet, nike free run, louis vuitton outlet, nike air max, polo ralph lauren, christian louboutin outlet, nike outlet, oakley sunglasses, burberry pas cher, oakley sunglasses, tiffany jewelry, louis vuitton, prada outlet, replica watches, ray ban sunglasses, jordan pas cher, sac longchamp pas cher, chanel handbags, tiffany and co, ugg boots, oakley sunglasses wholesale, longchamp outlet, uggs on sale, polo ralph lauren outlet online, christian louboutin uk, michael kors pas cher, gucci handbags, christian louboutin, christian louboutin shoes, prada handbags, nike roshe, nike free, air max, kate spade outlet, ray ban sunglasses, ugg boots, louboutin pas cher

oakleyses said...

michael kors outlet, hollister pas cher, ralph lauren uk, michael kors, north face uk, coach outlet store online, true religion outlet, mulberry uk, abercrombie and fitch uk, guess pas cher, true religion outlet, lululemon canada, ray ban pas cher, michael kors, uggs outlet, vans pas cher, nike free uk, michael kors outlet, michael kors outlet online, replica handbags, nike tn, michael kors outlet, oakley pas cher, burberry outlet, polo lacoste, nike air max uk, nike blazer pas cher, hollister uk, michael kors outlet online, sac hermes, uggs outlet, michael kors outlet online, burberry handbags, new balance, coach purses, true religion jeans, north face, kate spade, ray ban uk, michael kors outlet online, true religion outlet, nike air max, converse pas cher, nike air force, nike air max uk, nike roshe run uk, sac vanessa bruno

oakleyses said...

ghd hair, hollister clothing, ray ban, iphone cases, celine handbags, oakley, insanity workout, converse, abercrombie and fitch, instyler, gucci, lululemon, ferragamo shoes, baseball bats, nike huaraches, beats by dre, babyliss, louboutin, new balance shoes, mac cosmetics, hollister, herve leger, hermes belt, giuseppe zanotti outlet, timberland boots, vans, valentino shoes, nike trainers uk, asics running shoes, p90x workout, nfl jerseys, nike air max, vans outlet, reebok outlet, soccer shoes, north face outlet, soccer jerseys, converse outlet, longchamp uk, nike roshe run, wedding dresses, ralph lauren, hollister, bottega veneta, north face outlet, mont blanc pens, nike air max, jimmy choo outlet, mcm handbags, chi flat iron

oakleyses said...

canada goose outlet, canada goose, toms shoes, links of london, karen millen uk, doudoune moncler, pandora jewelry, louis vuitton, marc jacobs, montre pas cher, canada goose outlet, moncler uk, moncler, pandora charms, juicy couture outlet, louis vuitton, thomas sabo, replica watches, canada goose jackets, ugg uk, ugg, canada goose, ugg,uggs,uggs canada, louis vuitton, wedding dresses, juicy couture outlet, canada goose, swarovski, moncler, canada goose outlet, supra shoes, moncler outlet, lancel, coach outlet, canada goose uk, louis vuitton, moncler outlet, moncler, louis vuitton, swarovski crystal, ugg pas cher, barbour, pandora uk, barbour uk, ugg,ugg australia,ugg italia, moncler, hollister, pandora jewelry

raybanoutlet001 said...

coach outlet
ray ban sunglasses
los angeles lakers jerseys
ray ban sunglasses
fitflops shoes
jacksonville jaguars jersey
louis vuitton sacs
jordan shoes
arizona cardinals jerseys
air jordan uk