Why Object does n't exist error comes even when it is listed?

[Krishnan]

Hi,

I am a fresher to Oracle. I used DTS to import few tables from SQL Server
7.0 to Oracle 8i in the "SCOTT" account. When i try to query the data from
the imported table, i am getting the error that object doesn't exist. How
ever if i query through "select * from tab", I could see the table. Can any
one throw some light.

Thanks
Krishnan

[Harvinder Singh]

Hello,
There might be some control characters like " ' added to the names
of the names of the tables which you cannot see when you do a 'select * from
tab;' If you see a table in the above listing try describing the table by
enclosing the name with a " or ' and also try by putting the name in upper/lower
case.

Hope this hepls,

Harvinder Singh.



"Krishnan" <krish.vr@wipro.co.in> wrote:
>
>Hi,
>
>I am a fresher to Oracle. I used DTS to import few tables from SQL Server
>7.0 to Oracle 8i in the "SCOTT" account. When i try to query the data from
>the imported table, i am getting the error that object doesn't exist. How
>ever if i query through "select * from tab", I could see the table. Can
any
>one throw some light.
>
>Thanks
>Krishnan