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

Erwin can create database objects directly from the data model; however it is not recommended way to create database objects. You can have Erwin generates DDL, then run it manually as a USER. There may be different privileges or schemas. It looks like the owner of tables and owner of triggers could be different. First, try login as CBRADY,
SELECT TABLE_NAME FROM USER_TABLEs; or
SELECT TABLE_NAME FROM TABS; not ALL_TABLES. Then, try to query the tables as CBRADY.

• Joseph Suh dbtech_at_inetnow.net.usa *
• Oracle DBA 770-908-9785 *
• Database Technology Int'l, Inc. *
• Atlanta, Georgia *

  ---