Re: Schema Access

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 17 Jul 2002 13:15:24 +1000
Message-ID: <ed5Z8.36468$Hj3.110109@newsfeeds.bigpond.com>

Hi Yuel,

It's a new feature with 9i. It allows you to create tables but for security reasons they remain hidden and can not be accessed.

Only joking ;)

My guess is that you either created the tables while connected as a user different to the one which you thought you were in, or you are trying to access the table while logged in as a different user to which you think you are.

Query the dba_tables views and select the owner of the tables you can't access. Then logon as the table owner or put the owner prefix in front of the table name.

Easily done.

Richard

"Yuel Adorno" <yuel_at_contrada.com.au> wrote in message news:c44Z8.453280$o66.1221259_at_news-server.bigpond.net.au...
> I'm confused!
>
> Although I have generated my tables in my own schema I can't
> access my table => ORA-00942 table or view does not exist..
>
> What's wrong under Oracle9i?
>
> Thanks, Yuel
>
>
>
>
Received on Tue Jul 16 2002 - 22:15:24 CDT