It has to be something else since blowing away the old database would be the
way to correct the problem.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"John" <jwilson_at_napanet.net> wrote in message
news:394C1D2D.B388F6B6_at_napanet.net...
> Hi folks,
>
> OK, let's see where to start. I have a production database that seems
> to have a corrupted data dictionary. One user/schema has a number of
> views defined. We can see them in user_views; I can see them in
> dba_views, including the text.
>
> Yet, when logged into sqlplus as the user, if I tried to describe or
> select data from the view, it gives an ORA-04043 error indicating that
> the object doesn't exist. (it works on another system)....
>
> This morning, I took the db down, exported all of the data, totally blew
> away the database, recreated it from start, and imported the user's
> data. The problem exists.
>
> I've racked my brain over this so I'm looking for any help I can find on
> this one....
>
> Thanks,
>
> john
>
>
Received on Sun Jun 18 2000 - 00:00:00 CDT
