Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data import to remote DB (version 12.1) using imp.exe (version 12.2) fails with ora-00942 error

3378914Sep 4 2018 — edited Sep 4 2018

Hi,

I am trying to import data onto a remote DB using imp.exe of version 12.2 . The data was exported using export utility exp.exe of version 11.2 . The import is successful if the remote DB is also of 12.2 but if we try to import to 12.1 DB it fails with the following error:

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

export client uses AL32UTF8 character set (possible charset conversion)

IMP-00003: ORACLE error 942 encountered

ORA-00942: table or view does not exist

IMP-00023: Import views not installed, please notify your DBA

IMP-00000: Import terminated unsuccessfully

Am I missing out something?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2018

Added on Sep 4 2018

#general-database-discussions

16 comments

4,706 views