Re: Can a Table be Invalidated?

Andreas Sheriff wrote:

>Wow!

>A table *can* be invalidated after-all.

>Interesting...

But not for long:

SQL> / Type created.

SQL> create table test_tab of test_type;

Table created.

SQL> alter type test_type add attribute(test_att2 char(10)) invalidate;

Type altered.

SQL> SQL>
SQL> select object_name,object_type,status from obj where status =   2 'INVALID'; OBJECT_NAME

------------------ -------
TEST_TAB
TABLE              INVALID

SQL> SQL>
SQL> / OBJECT_NAME

------------------ -------
TEST_TAB
TABLE              INVALID

SQL> create view test_view as select * from test_tab;

View created.

SQL> select object_name,object_type,status from obj where status =   2 'INVALID'; no rows selected

SQL> SQL> Received on Mon Jul 18 2005 - 18:45:52 CDT