Oracle Database Discussions

Hi,

When i import the data the following error occured.

imp system/xxxx@yyyy.world fromuser=dmv_ace_ruh touser=dmv_ace_ruh file=F:\dmvaceruh.dmp log=F:\dmvaceruhimp.log ignore=y


fromuser=dmv_ace_ruh (exported by another database i.e database name is ACE)

OS = Sun solaris

touser=dmv_ace_ruh (database name is SAI)

OS = windows server 2003

Database Common 10g

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via direct path

Warning: the objects were exported by DMV_ACE_RUH, not by you

import done in AR8MSWIN1256 character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing DMV_ACE_RUH's objects into DMV_ACE_RUH
. . importing table "DMV_COVER_RISK_SMI_DISC_LOAD" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ALTER ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PREM_ACE_RUH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT DELETE ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PREM_ACE_RUH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT INDEX ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PREM_ACE_RUH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT INSERT ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PREM_ACE_RUH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PREM_ACE_RUH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT UPDATE ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PREM_ACE_RUH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT REFERENCES ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PREM_ACE_RUH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT ON COMMIT REFRESH ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'PREM_ACE_RUH' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT QUERY REWRITE ON "DMV_COVER_RISK_SMI_DISC_LOAD" TO "PREM_ACE_RUH""
IMP-00003: ORACLE error 1917 encountered

Regards

S.Azar
DBA

Edited by: azarmohds on Oct 5, 2009 5:11 AM