Skip to Main Content

Oracle Database Discussions

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!

Incremental export and import of Schema

939393Oct 26 2018 — edited Oct 30 2018

Hi Guru's,

DB Version:- 12cR2    

OS:- RHEL

Can anyone of you please let me know about there is any feature of expdp & impdp for incremental backup and restore. I study somewhere that after 8.1 this is deprecated. But my requirement is that one of the schema contains 10 tables which are updated on daily basis. I imported schema tables from DB A to DB B let say on 21st day of month. Now i want to import the incremental data which is updated after 21st to the data in machine B without doing the complete schema import so that only updated data is imported.

Any idea how to do the same.

Thanks in advance.

Comments
Post Details
Added on Oct 26 2018
1 comment
4,362 views