Hi All,
client has shared export dump files and informed to validate them by importing into a test database.
background:
export dump files are generated via 3rd party tool using "exp" utility.
issue:
when i try to import i get below error.
Warning: the objects were exported by abcd, not by you
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export client uses WE8MSWIN1252 character set (possible charset conversion)
. importing abcd's objects into abcd
. . importing table "table1" 0 rows imported
IMP-00017: following statement failed with ORACLE error 1917:
"GRANT SELECT ON "table1" TO "user1""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'user1' does not exist
About to enable constraints...
Import terminated successfully with warnings.
research done:
source and target databases have same character set ie; AL32UTF8
select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET'; ==>AL32UTF8
source is on 11.2.0.3 EE
target is on 11.2.0.4 EE
i tried as below but of no use.
set NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
export NLS_LANG
imp test123/test123 file=table1.dmp log=table1.log fromuser=abcd touser=test123
"GRANT SELECT ON "table1" TO "user1""
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'user1' does not exist
user1 does not exist in target database - exists in source
should i create user1 in target database and grant select privilege..? as i need only table1 to be imported into abcd (abcd schema exists in target)
Thanks,
Mohib