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!

Impact analysis after new columns added to table

500237Dec 1 2010 — edited Dec 1 2010
Hi All,

This is very typical scenario wherein I am asked to do the impact analysis after few new columns are added to the existing table.

I know few things where I can check what impact it would make at those places but do not have complete idea of whereall it can possibly impact.

I feel these are the things where new column addition can impact
1. All the depdendent SP's where there are DML statements without column names specified. 
2. Any triggers ??? 
3.
etc.
Could you please provide me some guideline about what all things might possibly get affected as a result if this table def change?

Thanks,
Aashish
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2010
Added on Dec 1 2010
6 comments
1,317 views