Re: Schema objects problem.

"Shabble" <gbarbour_at_baesystemsdotcom> wrote in message news:42b132b7$1_1_at_glkas0286.greenlnk.net...
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> JServer Release 8.1.7.0.0 - Production
> Solaris 8.
> ( Yes I know about 9, 10 etc, but these are vendor apps.)
>
> I have a schema fred who owns a number of objects.
> Something happened and now he isn't able to directly access them?!
> For example table = bob
>
> == Logged in as the fred schema. ==
> SQL> select * from bob;
> select * from bob
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> == and yet?
> SQL>
> SQL> select * from fred.bob;
> *
> * .. etc.
> 483 rows selected.
> SQL>
> Has anyone come across this before.

What is result of
select SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA') from dual;

???

> Apart from a full exp/imp on fred, is there another workaround?
> Grun.
>
>
Received on Thu Jun 16 2005 - 03:34:05 CDT