Dropping an archive database

To drop an archive database, use:

drop database <db name>

where db name is the database you want to drop.

When dropping an archive database, all the rows for that database are deleted from the sysaltusages table in the scratch database. This requires log space in the scratch database.