This content has been marked as final.
Show 17 replies
-
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 -
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. -
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 -
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. -
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 -
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.... -
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 ;) -
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.... -
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/ -
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
That is something totally new for me :)
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. -
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.... -
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/ -
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.... -
14. Re: IMP-00003: ORACLE error 942 encountered
amardeep.sidhu Aug 4, 2008 5:54 AM (in response to Aman....)