1 2 Previous Next 17 Replies Latest reply on Dec 28, 2010 12:39 AM by ggiulian

IMP-00003: ORACLE error 942 encountered

472194 Aug 1, 2008 2:59 AM

Hi All,

I have exported a schema in Oracle 9i and imported into Oracle 10g. But I got error as below. Kindly check if anyone have any idea about this error. Thanks.

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

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
export client uses US7ASCII character set (possible charset conversion)
. importing OMEDATA's objects into OMEDATA
. . importing partition "ALARM_HISTORY":"PART_2005_06_26" 23846 rows imported
. .
. .
. .
. . importing partition "ALARM_HISTORY":"PART_2008_07_20" 20010 rows imported
. . importing partition "ALARM_HISTORY":"PART_2008_07_27" 16547 rows imported
. . importing partition "ALARM_HISTORY":"PART_MAX" 11939 rows imported
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
. importing OMEDATA's objects into OMEDATA
. . importing table "ALARM_HISTORY_ARCHIVE" 0 rows imported
. importing OMEDATA's objects into OMEDATA
. . importing table "ALARM_LOG" 0 rows imported
. . importing table "ALARM_REPORT" 2127193 rows imported
. . importing table "ALARM_SOURCES" 4 rows imported
. . importing table "CALENDAR" 105 rows imported
. . importing partition "CTOOL_STATE_HISTORY":"PART_MAX" 0 rows imported
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist

Regards,
Tarman

1. Re: IMP-00003: ORACLE error 942 encountered

amardeep.sidhu Aug 1, 2008 4:29 AM (in response to 472194)

Have a look at the complete import log file. There must be some table creation errors for which its complaining.

Amardeep Sidhu

Message was edited by:
Amardeep Sidhu
Like Show 0 Likes(0)

Actions
2. Re: IMP-00003: ORACLE error 942 encountered

633234 Aug 1, 2008 7:20 AM (in response to amardeep.sidhu)

Hi......
Take export using 9i exp utility & then import with 10g utility.
Like Show 0 Likes(0)

Actions
3. Re: IMP-00003: ORACLE error 942 encountered

427256 Aug 1, 2008 7:21 AM (in response to 633234)

Some tables missing .. i think exp-imp shd work
Like Show 0 Likes(0)

Actions
4. Re: IMP-00003: ORACLE error 942 encountered

472194 Aug 4, 2008 1:22 AM (in response to 472194)

I have used exp in Oracle 9i for export and imp in Oracle 10g for import.

Regards,
Tarman.
Like Show 0 Likes(0)

Actions
5. Re: IMP-00003: ORACLE error 942 encountered

amardeep.sidhu Aug 4, 2008 2:06 AM (in response to 472194)

Did you check what i said above ?

Amardeep Sidhu
Like Show 0 Likes(0)

Actions
6. Re: IMP-00003: ORACLE error 942 encountered

Aman.... Aug 4, 2008 3:53 AM (in response to 427256)

Sapna,
What does this suppose to mean?
Aman....
Like Show 0 Likes(0)

Actions
7. Re: IMP-00003: ORACLE error 942 encountered

amardeep.sidhu Aug 4, 2008 5:00 AM (in response to Aman....)

Too bad of you man...you don't understand exp/imp ;)
Like Show 0 Likes(0)

Actions
8. Re: IMP-00003: ORACLE error 942 encountered

Aman.... Aug 4, 2008 5:00 AM (in response to amardeep.sidhu)

Ha ha well did I ever mention that I do ;-)?
Aman....
Like Show 0 Likes(0)

Actions
9. Re: IMP-00003: ORACLE error 942 encountered

Amit_DBA Aug 4, 2008 5:06 AM (in response to 472194)

You can try using trace=y option during import. This will trace a file similar to 10046 trace file in udump. This file will tell you the table for which you are getting ora-942.

Cheers
Amit
http://askdba.org/weblog/
Like Show 0 Likes(0)

Actions
10. Re: IMP-00003: ORACLE error 942 encountered

amardeep.sidhu Aug 4, 2008 5:26 AM (in response to Amit_DBA)

You can try using trace=y option during import. This
will trace a file similar to 10046 trace file in
udump. This file will tell you the table for which
you are getting ora-942.
That is something totally new for me :)
Like Show 0 Likes(0)

Actions
11. Re: IMP-00003: ORACLE error 942 encountered

Aman.... Aug 4, 2008 5:40 AM (in response to amardeep.sidhu)

It doesn't seem to be a documented option.I couldn't find anyting about it in the docs.
@Amit,
Is it a documented option or a hidden goodie?
Aman....
Like Show 0 Likes(0)

Actions
12. Re: IMP-00003: ORACLE error 942 encountered

Amit_DBA Aug 4, 2008 5:47 AM (in response to Aman....)

I think it is not documented but it does exists. Atleast till last time i tried myself ;-)

Cheers
Amit
http://askdba.org/weblog/
Like Show 0 Likes(0)

Actions
13. Re: IMP-00003: ORACLE error 942 encountered

Aman.... Aug 4, 2008 5:51 AM (in response to Amit_DBA)

Aah interesting. Yeah its not a documented feature, atleast not documented in Oracle's official public docs. Will give it a try for sure. Thanks for mentioning it.
Cheers
Aman....
Like Show 0 Likes(0)

Actions
14. Re: IMP-00003: ORACLE error 942 encountered

amardeep.sidhu Aug 4, 2008 5:54 AM (in response to Aman....)

It is an undocumented parameter.

Metalink Note 271782.1

Amardeep Sidhu
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.