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>
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 LarsenReceived on Sun Feb 27 2000 - 15:38:28 CET