-
Identifying Dependent Objects Before Removing A Table
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
-
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
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';
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
(USER_/ALL_)DBA_DEPENDENCIES
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Lol I knew someone smarter would come up behind me and knock me in the dirt :P
good call jmodic
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|