Have you tried the FROMUSER/TOUSER options (see IMP HELP=Y)?
Praveen wrote:
> Hi All,
>
> I have installed Oracle 10g on linux machine. I have taken an export
> of one schema successfuly and tried to import it to another new
> schema. the import giving error..
> "IMP-00003: ORACLE error 942 encountered ORA-00942: table or view
does
> not exist". It is showing this error on a table which is exported
> properly.
> I tried to import using "full=y", it works but, some tables will are
> missing.
>
> Can anybody tell me what might be the problem with IMP in oracle 10g?
>
> Thanks
> Praveen
Received on Tue Dec 21 2004 - 08:18:04 CST
