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

Home -> Community -> Usenet -> c.d.o.tools -> Re: cannot see tables

Re: cannot see tables

From: Jens Mander <jemand_at_microsoft.com>
Date: Mon, 2 Jul 2001 14:38:09 +0200
Message-ID: <H3iBbPvABHA.230@fnews1.vi-internet.de>

How abou mixed capital & small letters in tablenames ? When you are using ODBC you are allowed to do that, but actually Oracle doesn't like it

"Dave Nixon" <david_at_danix.freeserve.co.uk> schrieb im Newsbeitrag news:9hil1q$kdf$1_at_news5.svr.pol.co.uk...
> Hi
> I have imported 15 tables into the system user schema. When I logon to the
> databse as system/manager using the oracle odbc test i can connect ok but
> cannot see any tables when I click on 'user tables'. However if I do a
 query
> on a table that I know exists in the system users schema i get results.
> I can see other users tables when I logon as them..eg scott's tables are
> visible.
> Any ideas
> Dave
>
>
Received on Mon Jul 02 2001 - 07:38:09 CDT

Original text of this message

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