Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table seems not exist although scheme manager displays it
A couple of things could have gone wrong here:
BTW, it is not a good practice to create tables in Oracle from Access
for any
serious work. ODBC is like a least common denominator for most popular
databases
connected to Windows. Access has a few datatypes, which get messed up
in Oracle in a
ODBC table export. (e.g. Access has a datatype called 'Comments' which
gets converted
to Long in Oracle).
Have fun,
Raman Batra
Oracle DBA
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
Received on Thu Jul 17 1997 - 00:00:00 CDT