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

Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to access views

Re: Unable to access views

From: Gary England <gengland_at_hiwaay.net>
Date: 1997/09/23
Message-ID: <342876EA.2E31@hiwaay.net>#1/1

Arun Prabakar wrote:
>
> Hi,
>
> When I try to access views like USER_TABLES, etc. on 8.0.3 (as a user
> with dba
> priveleges) I get the error "ERROR: ORA-04043: object user_tables
> does not exist"
> but if I qualify that with SYS.USER_TABLES I am able to access the
> views fine. I
> have run the script catalog.sql as "sys" but that did not seem to
> help. I am sure that
> I must be doing something wrong but what ???
>
> TIA,
> AP

Sounds like you did not install the system synonyms when the db was created. Check with the release notes, but I think they would be in:

<oracle root>\admin\catalog.sql

May be risky running the whole thing. What you are after is:

create public synonym USER_TABLES for USER_TABLES

Might want to investigate why this standard synonym is missing. Could be other gone as well.

Good luck,
Gary England Received on Tue Sep 23 1997 - 00:00:00 CDT

Original text of this message

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