SQL Language (MOSC)

MOSC Banner

How to find all objects affected by a table definition change?

edited Dec 12, 2023 12:51AM in SQL Language (MOSC) 5 commentsAnswered

I am a dba supporting developers. They are wanting to know all objects that will be affected if they change the definition of a particular table. I have found that many different views have pieces of this information:

dba_dependencies

dba_views

dba_mviews

dba_source

I have gone through and pulled code using the dbms_metadata.get_ddl and instr'd on the table name. But now I need to also to do same for all the referenced tables. I can't be the first person who needs this information, so I am wondering if some script or utility already exists that I can use to find the information. This is the closest product category I see so asking here but if there is a better place to post the question, please let me know. Failing anything else, I'll write one, but I gotta figure it's

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center