CODEWITHSUNDEEP
oracle-database
Wolfgang
Wolfgang

Reputation: 575

Effect of adding new columns to existing table

In my project there is new requirement, in which I've to add two new columns to the existing table.

How I can analysis the effect of adding two new columns to this table?

Please note: I already find all dependencies using all_dependencies view and also I have used all_source to find few more information.

Could you please guide me what will be the right approach to follow in this project?

Edit1: As this question attracted the negative points. I would like to improve according to your suggestion.

Upvotes: 2

Views: 2152

Answers (1)

Utsav
Utsav

Reputation: 8143

Adding a column will not impact view/triggers/procedures, if the developers have used proper column names in them. But if someone used select * from your_table in any of the view/procedure/triggers, then you might be in trouble.

You are already on right path. Just check dba_source properly. Say your table name is schema1.table1, the do a search in all_source using where upper(text) like '%TABLE1%'

Also if there are dblink in other databases to your database, then you might need to take care of that too.

Upvotes: 2

Related Questions