Dropping a Shadow (Creating Databases)
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
DROP SHADOW 1;
If you need to look up the shadow number, use the
SHOW DATABASE; Database: employee.ib Shadow 1: 'employee.shd' auto PAGE_SIZE 1024 Number of DB pages allocated = 392 Sweep interval = 20000