Re: Table seems not exist although scheme manager displays it

Michael Jenc wrote:
>
> Hi,
>
> I have a strange problem. I have created a table through ODBC
> by exporting a MS Access Database. I can open the table from
> MS Access. I see the table and it's structure in Oracle Scheme
> Manager. But I can't us SQL Plus to select from that table.
> I get the error that the tabled does not exist.
> (I connected to the same user that I used for the ODBC-Connection).
>
> Any suggestions?
>
> Ciao
> Michael
> --
> *********************************************************
> Michael Jenc
> CAS Software GmbH
> Karlsruhe, Germany
>
> Replace the '_' with '-' in E-mail address to contact me
Hi, Oracle tablenames are case sensitive; the name you exported from Access might have lowercase characters in it. Oracle will see it - if you include it in double quotes (Select from "Emp"), or else try again

and use a name in  uppercase ..................  Chaim