How to find the owner of a table / view / materialized view?
Just_UDJun 22 2007 — edited Jun 23 2007Hello,
I can find the owner of a table using :
Select owner from dba_tables where table_name = 'name_of_table_to_search';
and I can find the owner of a view using :
Select owner from all_objects where UPPER ('object_name') = UPPER ('name_of_view_to_search');
but there are some tables/views that I couldn't found using that scripts, such as oe_order_headers_all and mtl_parameters. I can get the data if I use TOAD and execute :
Select * from oe_order_headers_all;
When I use :
Select owner from dba_tables where UPPER (table_name) like UPPER ('%oe_order_headers%');
I got information that the owner were JTM, ONT, XDP.
So how can I know who's the owner of oe_order_headers_all, mtl_parameters and other tables/views? Thanks