| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: lost view
sorry , there has been no changes to any underlying structures of this view.
i am the DBA and no one else has authorizations to change structures.
-james koopmann
jkoopm1_at_tandy.com
Hi!
The most probable cause was that someone has altered one of the tables in
view,
and the view fell into "INVALID" status. It's not neccessary to re-create
the
view, try with ALTER VIEW XXX COMPILE [FORCE];
If the cause is an alteration of a table, that shoul do the trick.
Kindest regards!
On Feb 3, 5:56am, James Koopmann wrote:
> Subject: lost view
> fellow users,
> i have come across an interesting problem that i hope someone else
> has come across and solved. our database has a view , composed of
> six tables and uses the outer join facility. this view has been in
> production
> for about 4 months with no problem. yesterday users were no longer
> able to select or even describe the object when it was there and all had
> select access on it. i ended up dropping the view, synonym and revoking
> access ; i then recreated the view , synonym and privileges and all was
> fine. after the users bang on the view for about 20-30 minutes (with no
> problems)
> the view becomes inaccessible again. this is not an authorization problem,
> the owner can not even describe or select from the view.
> please reply if you have had a similar experience. I will also repost
> the solution if it comes from oracle (or this list) and is solved.
>
>
--
Mladen Gogala
ASTER Ljubljana
Tel : ++386 61 1683-511 Snail-mail:
FAX : ++386 61 1683-165 ASTER Ljubljana
Email: gogi_at_aster.si Nade Ovcakove 1
WWW : www.aster.si 61000 Ljubljana
Slovenia
Received on Mon Feb 05 1996 - 09:41:35 CST
 |
 |