Dropping a Shadow (Creating Databases)

Go Up to Creating Databases (Data Definition Guide)

To stop shadowing, use the shadow number as an argument to the DROP SHADOW statement. DROP SHADOW deletes shadow references from a database’s metadata, as well as the physical files on disk.

A shadow can be dropped by its creator, the SYSDBA user, or any user with operating system root privileges.

DROP SHADOW Syntax:

DROP SHADOW set_num;

The following example drops all of the files associated with the shadow set
number 1:

DROP SHADOW 1;

If you need to look up the shadow number, use the isql command SHOW DATABASE.

SHOW DATABASE;
Database: employee.ib Shadow 1: 'employee.shd' auto PAGE_SIZE 1024 Number of DB pages allocated = 392 Sweep interval = 20000