Identifying Dependent Objects Before Removing A Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Identifying Dependent Objects Before Removing A Table

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    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

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Got OEM?
    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

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    yes. but i need to give this script to users.

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    (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?

  6. #6
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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
  •  


Click Here to Expand Forum to Full Width