Export/Import data only using data pump

Hi,

I have 2 tables (axium.trx , axium.history) in 2 databases. They have the same data but different indexes.

I need to refresh the data (just the data) in 2 tables in database 2 using the data from database 1 using data pump.
What the syntax (expdp, impdp) would be ?

Thanks,

Luchuan
luchuancAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
>>but different indexes.

I just remembered this requirement.  You will also need to tell expdp and impdp to not include indexes/constraints/??? and only do the tables and data.

If the link I posted doesn't show all the options, I'll defer to the online docs for your version.
0
 
slightwv (䄆 Netminder) Commented:
http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php#TableExpImp

expdp axium/password tables=TRX,HISTORY directory=TEST_DIR dumpfile=myTables.dmp logfile=expdpmytables.log

impdp axium/password tables=TRX,HISTORY directory=TEST_DIR dumpfile=myTables.dmp logfile=impdpmytables.log TABLE_EXISTS_ACTION=TRUNCATE
0
 
luchuancAuthor Commented:
Hi slightwv,

Is there any difference between using axium user and the system user in the command?

Thanks,

Luchuan
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
slightwv (䄆 Netminder) Commented:
I prefer a minimal privilege setup.  If you use system then that password will liekly be in some script somewhere.

I try to never hard-code the SYS or SYSTEM password.

Other than the security issue, there shouldn't be any.

You should just need to add the SCHEMAS and probably the INCLUDE options:
schemas=AXIUM include=TABLE:"IN ('TRX','HISTORY')"

You will just need to mess around with it until you get the results you want.
0
 
awking00Commented:
For just the data, include a "CONTENT=DATA_ONLY" statement in your expdp commands.
0
 
luchuancAuthor Commented:
Thanks a lot,

Luchuan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.