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

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

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

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

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,

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

Unknown said...

pandora charms
fitflops
canada goose uk
canada goose outlet
moncler
north face jackets clearance
prada outlet
canada goose outlet
jordan shoes
ugg on sale
201711.13wengdongdong

crackstools said...

Your website content is very effective and help full for people.I understood that you try to clear that concept about this subject.But i also read another content from another website. I think it's most better full content to your website content.So i suggest you, if you have a time to on your hand you will try to visit this website.http://crackstools.com

5689 said...

zzzzz2018.8.31
coach outlet
canada goose outlet
air max 90
nike factory outlet
nike huarache
christian louboutin sale
tods shoes
ugg boots on sale 70% off
tory burch handbags
adidas outlet online

Unknown said...

ysl handbags
adidas outlet
longchamp
nike air max
fila
jordan retro
goyard bags
jordan 4
adidas ultra boost
ultra boost

John said...

hermes
michael kors outlet clearance
ugg boots women
air jordan 14
coach outlet sale
hydro flask lids
canada goose outlet
christian louboutin sale
miu miu handbags
cheap snapbacks
yolo

Freshers Walkins said...

Useful Information :

Freshers Walkins provide information on all the job walkins happen in all over India. Popular IT Company jobs, Freshers walkins, java walkins, .net walkins @ http://fresherswalkins.co.in/

kelly said...

Best platform for sharing good things

Shariful said...

learn how to hypnotize anyone including yourself how does hypnosis work

yanmaneee said...

goyard
supreme t shirt
yeezy
supreme clothing
yeezy shoes
goyard handbags
moncler outlet
yeezy
yeezy supply
golden goose

SarkariNaukriHona Team said...

listoutnow.com Fantastic !

3party post said...

homescapes cheats
Homescpaes Cheats

Abbottabad Board ninth Class Result 2020 said...

There are five regions that go under the ward of Abbottabad Board of Intermediate and Secondary Education. These five regions are Haripur, Mansehra, Battagram, Kohistan and Torghar. The Board is trustworthy to coordinate the trial of all the backup private and government informative establishments that went under its domain. Abbottabad Board is furthermore famous among various sheets since it holds the tests in sensible, clear and demanding condition. The specialists of BISE Abbottabad also award the honors to the keen understudies who get position in yearly tests with the objective that they can go before with their further examinations.

claire said...

Click here for Psn Code Generator .
Click here for Psn Code Generator

SarkariNaukriHona Team said...

listoutnow.com Splendid !

Shawn said...

Quality Aircraft parts and Accessories repairs, overhauls, and exchanges aircraft parts and general aviation accessories. Explore the aircraft parts selection today!

Best IT Point said...

I read the post it is a very good post . Its really nice post. I hope its useful to everyone . Men's clothing

Andrea Elizabeth said...

Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Project Portfolio Management Cloud. Actually, I was looking for the same information on internet for
Oracle Financials Cloud and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Oracle Cloud Applications
.


Purple Pleasure People said...


Beste informatie, Wil je een dildo kopen, dan zorgen wij voor thuisbezorging, kom gewoon langs.

shyshour said...

bags replica ysl d47 p3c84t5m03 Ysl replica handbags i64 x8h08y3v42 gucci replica handbags j28 k4p35f5v18