Run Unloaddb
Note: Note on Steps 2 through 4: You can omit Steps 2 through 4 if procedures already exist to recreate all database objects and storage structures. However, it will be necessary to make the appropriate changes to the oi_prep.sh script-see the step Remove Non-table Objects-for re-modifying all tables.
Run unloaddb against each database. The unloaddb command does not unload the database; it simply creates scripts. You can edit these scripts to produce a collection of scripts that recreate various database objects and storage structures.
For Ingres Star databases, unload the CDB in the same way as for a local database. For a DDB, use unloaddb/star.
For a regular DB or CDB, issue this command:
unloaddb dbname
For an Ingres Star DDB, issue this command:
unloaddb ddbname/star