Re: Unable to access views

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