SQL query for finding the schema name of the tabale

1. select owner, table_name from all_tables where table_name like 'EMP_NAME';

2. select B.FILE_NAME from dba_segments a, dba_data_files b 
where a.header_file=b.file_ID and segment_name='EMP_NAME';