Views and base tables.

Hello all.

I am having problems with an Oracle form and it was suggested to me that some of the objects may be marked as invalid in dba_objects and this is causing me the problem.

I attempted to modify the status of these objects from invalid to valid using the update command. However I received an error about not being able to modify the view and that I must modify the base table which this view pulls from.

Does anyone the base tables which dba_objects pulls from? Better yet, is there a way I can see where the view is pulling it's information? Am I logged in and the wrong user?

We are running Oracle 7.3.3.3 on Solaris 2.6.

Thank you for your time.

Giovanni Arduini              |    Eckerd College
E-Mail: arduini_at_eckerd.edu    |    Information Technology Services
Phone:  (727) 864-8318        |    4200 54th Avenue South
Fax:    (727) 864-7733        |    Saint Petersburg, Fl  33711