Home -> Usenet -> comp.databases.oracle -> Newbie: Cant see tables from Client

Newbie: Cant see tables from Client

From: cris brady <cbrady_at_alpinenet.com>
Date: 1996/09/14
Message-ID: <01bba260$33da8660$145eb7cc_at_devbox40>#1/1 







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



Received on Sat Sep 14 1996 - 00:00:00 CEST












Original text of this message