Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the owner of a table / view / materialized view?

Just_UDJun 22 2007 — edited Jun 23 2007
Hello,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2007
Added on Jun 22 2007
2 comments
15,338 views