Dropping a Domain
Go Up to Working with Domains
DROP DOMAIN removes an existing domain definition from a database.
If a domain is currently used in any column definition in the database, the
DROP operation fails. To prevent failure, delete the columns based on the domain with
TABLE before executing
A domain can be dropped by its creator, the SYSDBA, and any users with operating system root privileges.
The syntax of
DROP DOMAIN is:
DROP DOMAIN name;
The following statement deletes a domain:
DROP DOMAIN COUNTRYNAME;