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!

IMP - 00058 occurs with ORA 942 error

515303Jul 4 2006 — edited Jul 5 2006

Hi All

while importing from a dump exported by 10gR2 on sun solaris to 10gR2 on windows i'm receiving the below error;

. . importing table "ATTACHMENT"
IMP-00058: ORACLE error 942 encountered
ORA-00942: table or view does not exist 0 rows imported

this is strange that i receive imp 00058 with ora 00942. This error is thrown when import utility tries to import the tables contains BLOB. Other objects are smoothly imported.

can anyone fix it

thnks in advance

chikki

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 2 2006

Added on Jul 4 2006

#general-database-discussions

4 comments

3,362 views