How am i able to find out which schema a table belongs to ?

[Jiangxi]

select * from tabs where table_name = ' xxxxx' ;

did not tell you which schema it belongs to, how to find out ? Thx.

[paulb]

You can query the all_tables view - there is an owner field in that view.

[liakat]

From user end...

select object_name,owner
from all_objects
where object_name='XXXXX';
or

select table_name,owner
from all_tables
where table_name='XXXXX';

From dba end....

quary dba_tables,dba_segments,dba_objects.

[PAVB]

quary dba_tables,dba_segments,dba_objects.

Thread was already solved by paulb and you suggest poster to "quary" dba_segments to find out the owner of a table?

I'm wondering why you didn't suggest to "quary" dba_tab_columns too