Re: Import problem in Oracle 10g

From: Denis Do <nospam.denisdo_at_yahoo.com>
Date: Thu, 23 Dec 2004 03:36:33 GMT
Message-ID: <slrncskfc2.3o0.nospam.denisdo@denisdo.news.google.com>

Try to make imp with SHOW=YES and doublecheck what is going on with your "wrong table"
What about NLS_ parameters? How did you name your tabe, I mean plain english or something "tricky"? Are you sure it is a table, not synonym? Are you using IGNORE=YES? (it is probably irrelevant but anyway)
What about TBS quotas and permisssions on OS level?

If you post part of logfile (NOT 1000 lines please :-) - that could give us a hint.

Marry Xmas!

On 2004-12-21, Praveen <spraveen2001_at_yahoo.com> 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 Wed Dec 22 2004 - 21:36:33 CST