| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Views and base tables.
A copy of this was sent to Giovanni Arduini <arduini_at_eckerd.edu>
(if that email address didn't require changing)
On Sun, 07 Feb 1999 14:53:00 -0500, you wrote:
>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.
>
you cannot make an object valid by updating its status. You must compile it.
For example:
SQL> alter package FOO compile;
SQL> alter view BAR compile;
and so on. There are also utilities to compile invalid objects in schemas, for example:
SQL> dbms_utility.compile_schema( 'SCOTT' );
>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
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sun Feb 07 1999 - 16:11:38 CST
 |
 |