Most major releases and some minor releases of Identity Manager include database table changes. Consequently, you might have to modify the sample SQL scripts for your environment.
You must also update the database tables if you made any of the following modifications:
Changed the database instance name
Changed the name of the database account that owns the database tables
Separated the owner of the database tables from the database account used to connect to the database
Made more advanced DBA changes, such as configuring specific table spaces and growth characteristics for different sets of tables and indexes
You must remember any changes that you make to the sample SQL scripts for each Identity Manager version and use source control to manage these changes. In the future, you will have to make similar changes to the sample SQL scripts for subsequent Identity Manager versions.