[SOLVED] Deleting Domains

[chrisplough]

I always forget how to do this and was just reminded (thanks Alan!), so I decided to post:

Note: This can't be undone - so make sure you REALLY want to delete a domain before you do so.

To delete a domain, you need to login to your database using sqlplus as the glogowner user. Alternately, you can also login to OTM as DBA.ADMIN and use the SQL Backdoor.

Once there, you just need to run:

SQL> exec domainman.delete_domain('DOMAINNAME')

where DOMAINNAME is the name of the domain you want to delete. If you're deleting a sub-domain then it would look something like:

SQL> exec domainman.delete_domain('DOMAINNAME/SUBDOMAIN')

The process will run for several minutes, as it deletes data. That's it!

Hope this helps!

--Chris