How to get the schema name when I have table name?

Question

I have a table name but I am not sure in which schema that table exists. How to find the schema name?

Answer 1

Select owner
from dba_tables
where table_name = 'YOUR_TABLE_NAME'

Here you can find something more.

Answer 2

Something like this should get the name of the table and the the schema it belongs to .

select owner, table_name 
 from all_tables 
 where table_name like 'GL%';