Skip to Main Content

Oracle Database Discussions

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!

find object dependencies through a column

SumuHadiJan 24 2024

howdy all,

Can anyone help me in finding object dependencies through a column.

Suppose there is a column that only needs to be deleted from the table but before deleting that column from the table we should know where else it (that column) exists in the entire database.

Means if col_A is present in tab_A on which a view (vew_A) is created along with that column (col_A) then col_A should not be deleted from tab_A but vew_A also.

how do we achieve it, kindly help?

Regards,

SK

Comments
Post Details
Added on Jan 24 2024
2 comments
625 views