To drop an archive database, use:
drop database <db name>
where db name is the name of 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.
If you run out of log space in the scratch database
while drop database is running, enter Ctrl+C, truncate
the log in the scratch database, and retry
the drop database command. Attempting to truncate
the log in the scratch database without first
entering Ctrl+C to end the drop
database command results in the truncation being suspended
as it waits on a lock that has been acquired by the drop command.
