DataPump Import (IMPDP) Fails With Errors ORA-39083 ORA-23403 During Create Refresh Group With REMAP_SCHEMA

(Doc ID 1457927.1)

Last updated on MAY 15, 2012

Applies to:

Oracle Server - Enterprise Edition - Version and later
Information in this document applies to any platform.


During importing the schema from source (APEX) to targt (APEX_GOLD) using REMAP_SCHEMA=APEX:APEX_GOLD you get the below errors:

ORA-39083: Object type REFRESH_GROUP failed to create with error:
ORA-23403: refresh group "APEX"."AUTHORIZATION" already exists
Failing sql is:
h_deferred_rpc=>TRUE,refresh_after_errors=>FALSE,purge_option =>
1,parallelism => 0,heap_size => 0);


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms