How to improve data pump import time in oracle

Question

313 views11/08/2022Oracle Database

0

Ezana886 11/08/2022 0 Comments

How to improve data pump import time in oracle? Parameter settings for improving data pump import.

Amen Answered question 11/08/2022

Write your answer.

score 0 · Answer 1 · 2022-08-11T18:25:03+00:00

For better and fast import of schema data objects using oracle data pump, impdp, the following parameters should be set:

The database should be in no archive log mode.
```
SQL > alter database noarchivelog;
```
The flashback mode of the database should be off.
```
SQL> alter database flashback off;
```
The database should be in no force log mode.
```
SQL > alter database no force logging;
```

While importing exclude statistics:.[apcode language="php"]

impdp system/password    directory=dirt  dumpfile=xx.dmp  exclude=statistics;

Disable the generation of redo log data.

impdp system/password    directory=dirt  dumpfile=xx.dmp  EXCLUDE=STATISTICS TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y