Page 2 of 2
Posted: Wed May 16, 2007 10:27 am
by admin
No you are doing excellent job by sharing your experience just meant that there is any example/sample output for better understanding for others. thanks
Posted: Thu Jun 14, 2007 3:31 am
by lukman
Hello,
how to find the owner of a view or materialized view? Can we use script:
SELECT owner
FROM dba_tables
WHERE table_name = 'table_name'
I tried to use it but failed. Thanks.
Posted: Fri Jun 15, 2007 3:00 am
by ahmadbilal
SELECT owner, object_name, object_type, created, status, last_ddl_time
FROM all_objects
WHERE UPPER (object_name) = UPPER ('Object Name')
Posted: Mon Jun 18, 2007 6:58 am
by lukman
Thanks for the script, it really helps.
Posted: Wed Jun 20, 2007 5:38 am
by lukman
hi,
using the script I got here I tried to find the owner of mtl_parameters. I found that the owner is apps but when I looked in schema browser with TOAD there's no mtl_parameters (though there are some views started with mtl_parameters). When I saw the script in mtl_parameters_view it referred to mtl_parameters too (but in that view's script there are 2 mtl_parameters with different alias, what's the reason for that?). So where's that mtl_parameters anyway? Thanks