Hello There,
The simplest solution what I can think of is creating a migration manager package when you add any attribute etc as this we apply on the higher environments instead of manually creating the same.We use the same for rollback also in case we wish to not proceed with the changes.
Instead of altering the data dictionary tables, it would be best to re-apply the same is what is my suggestion.
Thank you
------------------------------
Mahadevan Ramakrishnan
------------------------------