My Oracle Support Banner

DataPump Import (IMPDP) is Very Slow at Object/System/Role Grants, Default Roles (Doc ID 1267951.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 03-Oct-2014***

Symptoms

You started a database import using DataPump (impdp) with parameter METRICS=Y and observed that a huge amount of time is needed to import the object grants:

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Completed 475505 OBJECT_GRANT objects in 91490 seconds
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT
Completed 512310 OBJECT_GRANT objects in 124801 seconds
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Completed 1796 OBJECT_GRANT objects in 623 seconds

or system/role grants, default roles:

Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Completed 372 SYSTEM_GRANT objects in 706 seconds
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Completed 6455 ROLE_GRANT objects in 12267 seconds
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Completed 583 DEFAULT_ROLE objects in 1112 seconds


You extracted the SQL file with INCLUDE=OBJECT_GRANT (or SYSTEM_GRANT, ROLE_GRANT, DEFAULT_ROLE) SQLFILE=<filename> and ran this with SQL*Plus. This completed fast.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.