A. Upgrading from Ingres 6.4 : How You Upgrade from Ingres 6.4 Using Upgradedb (Alternate) : Recreate Objects
 
Share this page                  
Recreate Objects
Using the scripts generated by the step Edit the Unloaddb Output, recreate the views and other database objects.
Recreate objects in the following sequence:
1. Views, QUEL integrities, and grants:
sql -uuser dbname <user_grantview.sql
2. Dbevents:
sql -uuser dbname <user_event.sql
3. Database procedures:
sql -uuser dbname <user_dbsp.sql
4. Rules:
sql -uuser dbname <user_rule.sql
Remember to run all four scripts for each user who owns objects in each database.
If your application system has its own scripts to recreate database objects, you may use them instead of the unloaddb-generated scripts.