Re: Newbie: Cant see tables from Client

cris brady 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

Try logging on to SQL*Plus as a DBA user (system , sys etc) and then

	e.g
	select table_name,owner from dba_tables
	where table_name = 'CAT_XRE';

This will verify ownership
have you used the same username and password throughout the previous steps ? Received on Tue Sep 17 1996 - 00:00:00 CEST