Re: how can i delete WebDB site

From: Gorm Larsen <gorm_larsen_at_vestjyde.dk>
Date: Sun, 27 Feb 2000 15:38:28 +0100
Message-ID: <MPG.13235551369e01b89896a8_at_valhal>


In article <38B8FE6A.4A92EEE5_at_tele.nl>, gd_at_tele.nl says...

> Can someone suggest the way to delete one or more webdb sites.

In SQL-Plus:
Get the ID from wwv_modules$ where schema = your_schema_to_be_dropped. You can get the same ID several times (multiple versions of forms, reports etc.)
For every ID delete the corresponding records in wwv_module_details$. Delete the records in wwv_modules$ where schema =

your_schema_to_be_dropped.
Drop user your_schema_to_be_dropped cascade.
Drop user your_schema_to_be_dropped_admin cascade.
Drop user your_schema_to_be_dropped_public cascade.

HTH

-- 
Gorm Larsen
Received on Sun Feb 27 2000 - 15:38:28 CET

Original text of this message