Privileges errors in IMPDP

Posted by karthikmca.bhc on Oct 15, 2017; 10:37am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Privileges-errors-in-IMPDP-tp4003.html

Import: Release 12.1.0.2.0 - Production on Sun Oct 15 14:29:57 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded

Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/********@pieulx schemas=EU directory=DATA_PUMP_DIR dumpfile=ESIEU_%U.dmp logfile=EUimportesi.log parallel=20 include=statistics

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/STATISTICS/MARKER

EU.ACTDADISP_PK_PRIM : sqlerrm = ORA-20000: Unable to set values for index ACTDADISP_PK_PRIM: does not exist or insufficient privileges

EU.ACTMDDH_NTWKUID : sqlerrm = ORA-20000: Unable to set values for index ACTMDDH_NTWKUID: does not exist or insufficient privileges

EU.ACTMDDH_TRN : sqlerrm = ORA-20000: Unable to set values for index ACTMDDH_TRN: does not exist or insufficient privileges

EU.ACTMDD_FACL_NUK : sqlerrm = ORA-20000: Unable to set values for index ACTMDD_FACL_NUK: does not exist or insufficient privileges

EU.ACTMDD_MSUID : sqlerrm = ORA-20000: Unable to set values for index ACTMDD_MSUID: does not exist or insufficient privileges


Getting above error while importing

I exported the schema with include=statistics

but when importing with impdp im getting the above priviledge errors

Please advise for a fix

Thanks