import dump

Posted by Roshan on Oct 06, 2020; 6:21am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/import-dump-tp8832.html

Oracle Database 12.1.0.2

Hello Erman,

I have imported a dump file. I created all users required by the dump.

But I see Oracle reports some users not found. They are indeed present on DB.

Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_GAS_RW' does not exist
Failing sql is:
 GRANT "GOLD_GAS_RW" TO "GOLD_GAS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_GAS_RO' does not exist
Failing sql is:
 GRANT "GOLD_GAS_RO" TO "GOLD_GAS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'UMAPWALLET_RW' does not exist
Failing sql is:
 GRANT "UMAPWALLET_RW" TO "UMAPWALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'UMAPWALLET_RO' does not exist
Failing sql is:
 GRANT "UMAPWALLET_RO" TO "UMAPWALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'MSGFEEDPNS_RW' does not exist
Failing sql is:
 GRANT "MSGFEEDPNS_RW" TO "MSGFEEDPNS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'MSGFEEDPNS_RO' does not exist
Failing sql is:
 GRANT "MSGFEEDPNS_RO" TO "MSGFEEDPNS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'HKTWALLET_RW' does not exist
Failing sql is:
 GRANT "HKTWALLET_RW" TO "HKTWALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'HKTWALLET_RO' does not exist
Failing sql is:
 GRANT "HKTWALLET_RO" TO "HKTWALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_WALLET_RO' does not exist
Failing sql is:
 GRANT "GOLD_WALLET_RO" TO "GOLD_WALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_WALLET_RW' does not exist
Failing sql is:
 GRANT "GOLD_WALLET_RW" TO "GOLD_WALLET"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPP_RW' does not exist
Failing sql is:
 GRANT "GOLD_MPP_RW" TO "GOLD_MPP"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPP_RO' does not exist
Failing sql is:
 GRANT "GOLD_MPP_RO" TO "GOLD_MPP"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MSG_FEED_RW' does not exist
Failing sql is:
 GRANT "GOLD_MSG_FEED_RW" TO "GOLD_MSG_FEED"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MSG_FEED_RO' does not exist
Failing sql is:
 GRANT "GOLD_MSG_FEED_RO" TO "GOLD_MSG_FEED"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPP_SHADOW_RW' does not exist
Failing sql is:
 GRANT "GOLD_MPP_SHADOW_RW" TO "GOLD_MPP_SHADOW"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPP_SHADOW_RO' does not exist
Failing sql is:
 GRANT "GOLD_MPP_SHADOW_RO" TO "GOLD_MPP_SHADOW"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPS_RW' does not exist
Failing sql is:
 GRANT "GOLD_MPS_RW" TO "GOLD_MPS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_MPS_RO' does not exist
Failing sql is:
 GRANT "GOLD_MPS_RO" TO "GOLD_MPS"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_BPM_RW' does not exist
Failing sql is:
 GRANT "GOLD_BPM_RW" TO "GOLD_BPM"
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01919: role 'GOLD_BPM_RO' does not exist
Failing sql is:



SQL> create role GOLD_GAS_RW;
create role GOLD_GAS_RW
            *
ERROR at line 1:
ORA-01921: role name 'GOLD_GAS_RW' conflicts with another user or role name

Kindly advise.

Regards,

Roshan