i need to find all dependent objects (
Synonym,views,triggers,grants,constraints,indexes)
and their related details
for recreating purpose of the same, on a particular table,
through sql plus.
Is there any script available for the same..?
Thanks
Printable View
i need to find all dependent objects (
Synonym,views,triggers,grants,constraints,indexes)
and their related details
for recreating purpose of the same, on a particular table,
through sql plus.
Is there any script available for the same..?
Thanks
Got OEM?
yes. but i need to give this script to users.
Ahhh,
well you can log on as the owner of the object and query the associated "object tables" that belong to that table. Like this
select * from user_triggers
where table_name='your_table';
select * from user_synonyms
where table_name='your_table';
(USER_/ALL_)DBA_DEPENDENCIES
Lol I knew someone smarter would come up behind me and knock me in the dirt :P
good call jmodic