Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > metadata reposi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 16464 of 16958
Post > Topic >>

metadata repository using exp vs expdp

by Ben <benalvey@[EMAIL PROTECTED] > Apr 24, 2008 at 12:17 PM

10.2.0.2 EE, aix5.2 64bit

I'm implenting a metadata repository to track changes in the database
and wanted to try to use datapump instead of ex****t but when I tried
to switch I found that datapump took about 3 times the amount of time
to do the ex****t. I've searched metalink and can't find any bugs
related specifically to content=metadata_only. Has anyone else
experienced this? I'm wondering if it isn't something specific about
the various schemas in my database that is causing the problems.

Here are the parameters I used for each.

ex****t:
DIRECT=y
FILE=exp_wasdev_meta_041508_11.dmp
FULL=y
COMPRESS=n
ROWS=n
INDEXES=y
CONSTRAINTS=y
LOG=/out/oracle/ex****t/nightly/exp_wasdev_meta.log


datapump:
$OHOME/bin/expdp user/pwd
content=metadata_only
full=y
directory=DATA_PUMP_DIR
dumpfile=tst%U.dmp
parallel=4
 




 1 Posts in Topic:
metadata repository using exp vs expdp
Ben <benalvey@[EMAIL P  2008-04-24 12:17:11 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 2:15:34 CDT 2008.