Re: Newbie: Cant see tables from Client

"cris brady" <cbrady_at_alpinenet.com> wrote:

>Hi everybody,
 

>I'm new to the Oracle world and would appreciate some help.
 

>I'm trying to get an Oracle server up and running. I'm running the
>Workgroup Server on NT. I have a Erwin data model that I'm using to create
>the tables on the server. When I generated the schema from Erwin it created
>the tables but bombed out when creating the RI triggers. The error was it
>couldn't find the table or view. It was a simple trigger that reference two
>tables and checked for their existance.
 

>So off to the server, fired up Object Manager and checked the tables. Well,
>all tables were created according to it. Drill down showed me the
>structure.
 

>From the client workstation, I ran SQL Plus and ran a query:
> select table_name from ALL_TABLES where owner = 'CBRADY'
>It showed me all 25 tables. When I tried querying any of the tables, such
>as "SELECT * FROM cat_xre", I get the following error:
> ERROR at line1:
> ORA-00942: table or view does not exist
 

>I can't Select from the tables or Drop them. However, they show up in the
>data dictionary. I'm logged on as me, and I have all rights (as far as I
>know). I figure its probadly a rights problem, but if so, why could I
>create the table in the first place?
 

>Currently I'm stumped. Suggestions appreciated.

>-- Cris

Are the tables created using mixed lower case? If so, then you need to access them using double quotes, like this:

SELECT * FROM "cat_cre"

Lower-case table and column names are possible in Oracle, but are a pain in the butt. I suggest you drop all of the tables and start over, making sure that the physical name that ERWIN uses for the tables/columns are all in upper case. Use:

DROP TABLE "table_name" CASCADE CONSTRAINTS;

to drop the tables.

Mike Received on Mon Sep 16 1996 - 00:00:00 CEST