imp import error

zzz111

Warning: This object was exported by XFSB, not the current user

The ZHS16CGB231280 character set and the ZHS16CGB231280 NCHAR character set have been imported
List only the contents of the import file (yes / no): no>

Since the object already exists, ignore creation errors (yes / no): no> yes

Import permissions (yes / no): yes>

Import table data (yes / no): yes>

Import the entire export file (yes / no): no> yes

. Importing XFSB objects into AA
.. Is importing table "YL_WLCX_GR" 238592 rows are being imported
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT ALTER ON" YL_WLCX_GR "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT DELETE ON" YL_WLCX_GR "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT INDEX ON" YL_WLCX_GR "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT INSERT ON" YL_WLCX_GR "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT SELECT ON" YL_WLCX_GR "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT UPDATE ON" YL_WLCX_GR "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT REFERENCES ON" YL_WLCX_GR "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
.. Importing table "YL_WLCX_ZH" 3261994 rows are being imported
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT ALTER ON" YL_WLCX_ZH "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT DELETE ON" YL_WLCX_ZH "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT INDEX ON" YL_WLCX_ZH "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT INSERT ON" YL_WLCX_ZH "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT SELECT ON" YL_WLCX_ZH "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT UPDATE ON" YL_WLCX_ZH "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist
IMP-00017: The following statement failed due to ORACLE error 1917
 "GRANT REFERENCES ON" YL_WLCX_ZH "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist

whbilly

The user you execute imp has dba permission

whbilly

IMP-00017: Due to ORACLE error 1917, the following statement fails
 "GRANT ALTER ON" YL_WLCX_GR "TO" LIANGJ ""
IMP-00003: ORACLE error 1917 appears
ORA-01917: user or role 'LIANGJ' does not exist


The authorization statement is unsuccessful because your user LIANGJ does not exist, the prompt is very clear

zz810442600

How to create the above LIANGJ user?

renkui1981

You export the create user statement of the original library user XFSB, replace it with LIANGJ and execute it.

gf90328

IMP-00003: ORACLE error 1917 occurred
ORA-01917: user or role'LIANGJ' does not exist

renkui1981

USERS under plsql, click User View View SQL

dlweiwei521

I also had a similar situation, but there was no error when exporting, why did the import report an error? How to solve it? Please help from the masters, thank you very much!

awxcvv1234

Switch users when importing
fromuser=LIANGJ touser=xxx

chl1987

It should be the reason why there is no extra authority.