Dropping an archive database

To drop an archive database, use the following, where dbname is the database you want to drop:

drop database dbname

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.