Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Append data using EXPDP/IMPDP

NadviJun 3 2010 — edited Jun 3 2010

I have a log table which is exported daily and imported to another schema. currently what I do is, export the LOG table, drop the existing LOG table on target schema and then import in there.
Is it possible to append only last days data to the target schema's table rather exporting full table and importing daily?

Current exp/imp command:
expdp system/XXXX SCHEMAS=LOG INCLUDE=TABLE:"IN('DAILY_LOGGER')" directory=dumpdata dumpfile=daily_logger.dmp logfile=daily_logger_exp.log

impdp system/xxx REMAP_SCHEMA=LOG:LOG_BKP directory=dumpdata PARALLEL=1 dumpfile=daily_logger.dm logfile=daily_logger.dmp_imp.log'

DB Version:
BANNER
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

OS Version:
Linux CLIENT1 2.6.18-128.el5 #1 SMP Wed Jan 21 08:45:05 EST 2009 x86_64 x86_64 x86_64 GNU/Linux

Thanks

Edited by: Nadvi on Jun 3, 2010 11:11 PM

This post has been answered by Dean Gagne-Oracle on Jun 3 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2010

Added on Jun 3 2010

#11g, #database-key-features, #export-import-sql-loader-external-tables

10 comments

5,323 views