SQL*Plus: Release 11.1.0.6.0 - Production on Fri Mar 14 18:21:48 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select status, count(*) from dba_objects group by status;

STATUS    COUNT(*)
------- ----------
INVALID          1
VALID        68591

SQL> create procedure prc_invalid as
  2  begin
  3    select 'x' from dual;
  4  end;
  5  /

Warning: Procedure created with compilation errors.

SQL> exec prc_invalid;
BEGIN prc_invalid; END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object SCOTT.PRC_INVALID is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


SQL>

SQL> create table tab_invalid (abc number);

Table created.

SQL> create synonym syn_invalid for tab_invalid;

Synonym created.

SQL> drop table tab_invalid;

Table dropped.

SQL> select * From syn_invalid;
select * From syn_invalid
              *
ERROR at line 1:
ORA-00980: synonym translation is no longer valid


SQL>

Parasiting  
I want a position I said I could do
      But haven't experience to back what I knew
So I post in the forum -  my defacto mentor
     Brain dump your knowledge to this genus stentor
I need it right now, it's an URGENT request!
  	You've done it all, what would you suggest?
'RTFM', I think not my DEAR friend
  	I just asked for the steps, beginning to end.

       				--Author dbtoo