Using the drop domain, you can delete a security domain.

Syntax

DROP DOMAIN domain_name;

Parameters

domain_name

Specifies the name of the security domain.

Note: To drop a domain, you must first drop all the users associated with the domain.

Note

Each database contains tenants, users, and domains. A DBA must complete the steps specified below to drop a tenant from the database:

  1. DROP USER for every user in the domain. For more information on dropping a user.
  2. DROP DOMAIN for every domain defined for the tenant.
  3. DROP TENANT.

Example

The syntax shown below shows how to drop a domain. 

DROP DOMAIN jasper;