6. Loading and Unloading Databases : Copy Operation : Scripts Produced by the Copy Database Operation : Reloading Order
 
Share this page                  
Reloading Order
When using the copy.in script, database objects are reloaded in the following order:
Users, groups, and roles (only when recreating the iidbdb)
Tables
ALTER TABLE statements are used as needed for deferred creation of referential integrities.
Data
The unload database operation (using the unloaddb command) handles all data types, including decimal data, large objects, and User Data Types (UDTs). More information can be found in Considerations When Loading Large Objects and Column Name and Format Specifications.
Table permissions
Permissions are recreated to the original time stamp order, and can or cannot be those of the table owner (depending on the grant options for the table).
Indexes, index modifications, and integrities
Views and related permissions
Like tables, these are recreated to the original time stamp order.
Synonyms
Database procedures and related permissions
Procedures depend on tables, views, events, and synonyms. Procedures can also see other procedures. To handle reloading of procedures, two passes are made during the unload database process through the iiprocedures catalog (see iiprocedures Catalog).
Comments