Query user_objects for object status : user_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. user_objects

SQL>
SQL>
SQL> create table t ( x int );

Table created.

SQL>
SQL> create or replace view v as select * from t;

View created.

SQL>
SQL> create or replace procedure p
  2  as
  3  begin
  4          for x in ( select * from t )
  5          loop
  6                  null;
  7          end loop;
  8  end;
  9  /



SQL>
SQL> create or replace function f return number
  2  as
  3          countValue number;
  4  begin
  5          select count(*) into countValue from t;
  6          return countValue;
  7  end;
  8  /

Function created.

SQL>
SQL>
SQL> alter table t add y number
  2  /

Table altered.

SQL>
SQL> select object_name, object_type, status from user_objects
  2  where rownum < 10
  3  /

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS
------------------- -------
MYSTATS
INDEX               VALID

MYSTATS
TABLE               VALID

S
SEQUENCE            VALID


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS
------------------- -------
P_ADD_ITEMS
PROCEDURE           INVALID

WORKING_CUSTOMERS
TABLE               VALID

ADDTUPLE3
PROCEDURE           INVALID


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS
------------------- -------
P_ADD_ORDERS
PROCEDURE           INVALID

P_ADD_PROD
PROCEDURE           INVALID

UPDATE_PRODUCT_PRICE
PROCEDURE           INVALID


9 rows selected.

SQL>
SQL> drop table t;

Table dropped.