A. Upgrading from Ingres 6.4 : How You Upgrade from Ingres 6.4 Using Unload/Reload : Check for Obsolete Users
 
Share this page                  
Check for Obsolete Users
Old databases may have objects created by users who no longer exist. Check for obsolete users for each database.
To check for obsolete users:
1. Examine the scripts created by unloaddb earlier in the upgrade procedure.
Each script contains one line for each user who owns a database object.
2. Make sure that all users listed are valid.
3. If obsolete users are found, delete the relevant lines from the scripts.
4. Delete the cp{user}.in and cp{user}.out files.
5. Go into the database and clean out these unwanted objects.