Skip to Main Content
Forums

SQL & PL/SQL

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!

how to do incremental import via dump...

mariasAug 26 2009 — edited Aug 26 2009
i have the table inf_products_dim.
as one time load i used .dmp option (ie export/import).
from now onwards, shall we do incremental dump ie export/import?

ex: on 20-aug-2009 we dumped using (imp/exp) 1200 records into inf_products_dim (this is as part of initial load)
now on 26-aug-2009 we need to load 6 days of data into inf_products_dim. ie (incremental which will have updated/new records based on inventory_item_id)
shall we export that 6 days of data and import (MERGE) into inf_products_dim using .dmp file?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2009
Added on Aug 26 2009
6 comments
2,131 views