Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import problem in Oracle 10g

Re: Import problem in Oracle 10g

From: hastenthunder <hastenthunder_at_hotmail.com>
Date: Tue, 21 Dec 2004 09:23:51 -0500
Message-ID: <XlWxd.2264$Ny6.3734@mencken.net.nih.gov>


This is not an answer..., but.
You may want to take a look at Oracle 10g's Data-pump, I've used it and it really outperforms exp/imp.

"Praveen" <spraveen2001_at_yahoo.com> wrote in message news:98d8ec76.0412210604.6e0a0d11_at_posting.google.com...
> 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:23:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US