Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2018
Added on Sep 4 2018
#general-database-discussions
16 comments
4,524 views