Re: invalid views

From: Thomas Day <tomday2_at_gmail.com>
Date: Fri, 22 Sep 2006 09:45:24 -0400
Message-ID: <a8c504590609220645h543b18e2p6578ff0df167e9ec@mail.gmail.com>

How is your developer fixing this problem? I've had views go invalid in the past, but if the base table(s) were unchanged, doing a select on the view always changed its status to valid.

SQL> create table gorp (gorp1 number);

Table created.

SQL> insert into gorp values (5);

1 row created.

SQL> create view gorp5 as (select * from gorp where gorp1 = 5);

View created.

SQL> select * from gorp5;

GORP1

1 row selected.

SQL> rename gorp to prog;

Table renamed.

SQL> select * from gorp5;
select * from gorp5

*
ERROR at line 1:
ORA-04063: view "GORP5" has errors

SQL> select object_name , object_type, status from dba_objects where object_name = 'GORP5';

OBJECT_NAME

OBJECT_TYPE STATUS
------------------ -------

GORP5
VIEW INVALID 1 row selected.

SQL> RENAME PROG TO GORP; Table renamed.