select owner, object_type, status object_status, count(*)
from dba_objects
where status <> 'VALID'
group by owner, object_type, status

OWNER                          OBJECT_TYPE         OBJECT_STATUS   COUNT(*)
------------------------------ ------------------- ------------- ----------
APPLICATIONUSR                   SYNONYM             INVALID                9

CREATE OR REPLACE PROCEDURE WEBSYSTEM.BKUP_TABLES
IS
   V_Table_Present   NUMBER
BEGIN
      
	  BEGIN
	  SELECT COUNT (*)
        INTO V_Table_Present
        FROM user_tables
       WHERE table_name IN
                ('PYCOMMONTEMPLATE_BKUP',
                 ....
				 ....);
   EXCEPTION
      WHEN NO_DATA_FOUND
      THEN
         V_Table_Present := 0;
   END;
   IF V_Table_Present > 0 then
  EXECUTE IMMEDIATE 'drop table PYCOMMONTEMPLATE_BKUP';
...
...
  end if;

      EXECUTE IMMEDIATE
         'create table  PYCOMMONTEMPLATE_BKUP as select * from  PAYMENTSCOMMONTEMPLATE';
	....
	EXECUTE IMMEDIATE
         'Grant select on PYCOMMONTEMPLATE_BKUP to READ_ONLYROLE,APPLICATIONUSR';
        ....
		....
END;