Skip to Main Content
  • Questions

  • More archives during impdp, what is the exact reason and what will happen internally

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Guduru.

Asked: October 04, 2018 - 7:26 am UTC

Last updated: October 06, 2018 - 5:58 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Why more archives will be generated during import (impdp) activity, i would like to know what will happen internally due to which more archives being generated. Is it only for import activity or it will generate more redo for export as well ?

Many thanks in advance.,

Regards,
Balaji

and Connor said...

Import is conceptually not much different to the series commands you would use to load data yourself, ie for each table in the import file we do:

- create table
- a series of inserts to load the data

So just like inserting 1,000,000 rows will consume a lot of archives, then importing a table with 1,000,000 rows will consume a similar amount of archives.

In recent version of Oracle, we have the

TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y

parameter on import to allow less redo log to be generated, but this is not available on 11.2.0.4

You are unlikely to see and significant additional redo generation during an export.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Cleared

Balaji, October 05, 2018 - 5:45 am UTC

Thank you very much Mcdonald for your valuable inputs.


Connor McDonald
October 06, 2018 - 5:58 am UTC

glad we could help
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.