HOW TO CHECK ALL TABLES FOR A PARTICULAR SCHEMA :

SELECT DISTINCT OWNER, OBJECT_NAME
  FROM DBA_OBJECTS
 WHERE OBJECT_TYPE = 'TABLE'
   AND OWNER = 'SCHEMA_NAME';