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.
Apart from a full exp/imp on fred, is there another workaround?
Grun.
Received on Thu Jun 16 2005 - 03:13:27 CDT
