Re: Object does not exist

Hong Zhou wrote:
>
> I export an Access table to Oracle. I can see it in Oracle data
> dictionary, but can not do anything to it. I keep getting
> ORA-00942 , saying table or view does not exist.
> I export serveral other, they all worked fine.
> I even can link it through Access. But in SQL*Plus, I can not do
> anything about it.
> I don't know whta's wrong, and how can I drop it?
>
> Thanks
>
> BTW, I am using Personal Oracle 95Bonjour,

    Try to see in which user or schema did you import the table to ! I hope this helps.

Joseph D. Sumalbag
Filipino DBA in Canada

-- 
Lord Raiden
Thunder Deity 

It is not the weapon that makes a warrior ........
But it is the spirit by which he wields it ........
Your spirit is your true shield ...................

                                           O-Sensei