Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Table seems not exist although scheme manager displays it

Re: Table seems not exist although scheme manager displays it

From: raman batra <rrbatra_at_feist.com>
Date: 1997/07/17
Message-ID: <33CEDDCF.6B71@feist.com>#1/1

A couple of things could have gone wrong here:

  1. Oracle put underscores (eg. employee data became employee_data)
  2. Oracle created tables which are case-sensitive (normal in ODBC). In SQL *Plus do : select * from cat This shall list the table and views under a user's schema. If you see a table name which is a combination of upper/lower case then use quotes around your table_name in your select/update/insert/delete statements: e.g. You may have Employee_Data instead of employee_data Use select * from 'Employee_Data' in such a situation then.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US