| |

VerySource

 Forgot password?
 Register
Search
View: 26|Reply: 10

imp import error

[Copy link]

2

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

Post time: 2020-2-22 22:00:01
| Show all posts |Read mode
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
Reply

Use magic Report

0

Threads

69

Posts

48

Credits

Newbie

Rank: 1

Credits
48

 China

Post time: 2020-5-4 14:00:02
| Show all posts
The user you execute imp has dba permission
Reply

Use magic Report

0

Threads

69

Posts

48

Credits

Newbie

Rank: 1

Credits
48

 China

Post time: 2020-5-4 16:00:01
| Show all posts
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
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-8-29 22:45:01
| Show all posts
How to create the above LIANGJ user?
Reply

Use magic Report

0

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-8-29 23:15:01
| Show all posts
You export the create user statement of the original library user XFSB, replace it with LIANGJ and execute it.
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-8-30 11:45:01
| Show all posts
IMP-00003: ORACLE error 1917 occurred
ORA-01917: user or role'LIANGJ' does not exist
Reply

Use magic Report

0

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-8-30 12:00:01
| Show all posts
USERS under plsql, click User View View SQL
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-9-5 09:30:01
| Show all posts
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!
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-9-5 09:45:02
| Show all posts
Switch users when importing
fromuser=LIANGJ touser=xxx
Reply

Use magic Report

0

Threads

1

Posts

2

Credits

Newbie

Rank: 1

Credits
2

 China

Post time: 2020-9-5 10:00:01
| Show all posts
It should be the reason why there is no extra authority.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list