Skip to Main Content
Forums

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!

Incremental EXPDP !!!

587724Oct 16 2009 — edited Mar 25 2013
Dear all,

I have a production database on windows 2003 server 64 bit with oracle 10.2.0.3 installed. This db has a schema which expdp file is of 33gb, every day I am taking the schema level export and importing the same to my test server.

Moreover, we also had configured flashback database.

Its taking a lot of time to import everyday despite there is little changes in the schema. Our intention is to refresh the test schema every day.

Is there a way to take the incremental expdp/flashback to record only the changes and then import it into the test server.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2013
Added on Oct 16 2009
#database-key-features, #export-import-sql-loader-external-tables
17 comments
7,670 views