Re: No user_tables?

That's odd. CATALOG.SQL takes care of that. How did you get your database? When logged on as SYS (or INTERNAL) you may rerun CATALOG

Joseph Conrad wrote:

> Hello everyone -
>
> I'm fairly new to Oracle, so please forgive me if the answer to this is
> obvious, but...
>
> I just downloaded & installed Oracle 8 Enterprise Edition for Windows NT.
> The install process went smoothly, and I can work with the database just
> fine, except, for example, the user "scott" has no user_tables view. Nor an
> all_tables view. The "demo" user has the sample problem:
>
> SQL> describe user_tables;
> ERROR:
> ORA-04043: object user_tables does not exist
>
> Now, if I log on as the "SYS" user, I *can* see user_tables, all_tables,
> etc - all the rest of the Oracle Data Dictionary. So what is the problem
> here? If I create a new user, the new user does not get user_tables,
> either.
>
> Any clues, anyone?
>
> Thanks in advance,
>
> -Joe

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046