Please specify the exp and imp command you used.
It looks like the table which you are trying to import is not available in the export dump.
It is advised to do expdp/impdp instead of original exp/imp in 11g/12c systems.
Perhaps you need to run catexp.sql in your 12.1 database.
I am using the following query:
imp.exe 'sys/Password@DBServer:Port/ServiceName as sysdba'
FILE='Path of the dump file'
LOG='Path of the log'
This was the same dump file using which the import was successful if the DB is 12.2 .
I tried to do that but the import still fails with the same error.
Come, on, man! What happened when you "tried"? Did the views get created? Can you see them?
No views created. Its the same ora-00942 error again. This is my log:
Connected to: Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Export file created by EXPORT:V11.02.00 via conventional path
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
I'll try one more time. I asked if you had run the catexp.sql script. You said that you had "tried" to do so. What was the result of this "trying"? Did it create exp/imp views correctly?
Yeah. The script ran successfully in 12.1 DB and the imp/exp views are created.
However, when I run the import command after this it fails with ora-00942 error.
Why do you think the script ran successfully? How do you know the views were created? Can you decscribe them? Are they valid?
When a process reports an error, you need to investigate the error, not merely repeat it.
Please use parameter VERSION=11.2 during export.
Version is a parameter for a datapump export (expdp), but not for the 'old' export (exp.exe) which is used by the OP.
I ran the following query :
select * from tab where tname like 'EXU%'
It gave me the list of views created but there was no information if they are valid or not. Can I find that status somewhere?
Just query dba_objects. It has a column named 'status'.
Let me summarize the situation:
You do not show what you are doing. You do not show the results of any queries or of any script runs. You do not know how to determine if a view is valid (hint: dba_objects). You do not know what views should exist (hint: look at the script that creates them). It took repeated requests for you to do anything other than repeat the attempted import. You have applied no problem solving, or even information gathering, technique.
It does not look as though my attempts to assist have been of any value. Perhaps someone else can help. Goodbye.