Privileges errors in IMPDP

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Privileges errors in IMPDP

karthikmca.bhc
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
Reply | Threaded
Open this post in threaded view
|

Re: Privileges errors in IMPDP

ErmanArslansOracleBlog
Administrator
See this note -> ORA-20000 Unable to Set Values for Index XX: Does Not Exist or Insufficient Priv is Raised While Executing Impdp (Doc ID 2176364.1)

It says:

- Add include=index while executing expdp
  "and"
- Add include=statistics while executing impdp
Reply | Threaded
Open this post in threaded view
|

Re: Privileges errors in IMPDP

karthikmca.bhc
Thanks Erman for the support. It worked.