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!

Column dependency in view

MukundhanJul 8 2014 — edited Jul 9 2014

I need to delete a column from a table. Is there a way to find all views that reference this column? There are no PL/SQL objects (packages, procedures, function) in my database, so no worries there.

I don't want to query ALL_SOURCE because there are too many objects.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2014

Added on Jul 8 2014

#general-database-discussions

8 comments

3,438 views