Adaptive Server generally clears all unused pages in the database device when you create a new database. Clearing the pages can take several seconds or several minutes to complete, depending on the size of the database and the speed of your system.
Use the for load option if you are going to use the database for loading from a database dump, either for recovery from media failure or for moving a database from one machine to another. Using for load runs a streamlined version of create database that skips the page-clearing step, and creates a target database that can be used only for loading a dump.
If you create a database using for load, you can run only the following commands in the new database before loading a database dump:
alter database...for load
drop database
load database
When you load a database dump, the new database device allocations for the database need to match the usage allocations in the dumped database. See Chapter 27, “Backing Up and Restoring User Databases,” for a discussion of duplicating space allocation.
After you load the database dump into the new database, there are no restrictions on the commands you can use.