Re: how can i delete WebDB site
Date: Mon, 28 Feb 2000 20:30:30 -0600
Message-ID: <89f7c8$4pr$1_at_inet16.us.oracle.com>
PURPOSE This documentation contains the procedure necessary to delete a WebDB site. There is currently no Drop Site link on the Site Administration page and sites must be deleted manually via SQL*Plus.
SCOPE & APPLICATION The information in this document targets WebDB users, site administrators, and support analysts.
In order to delete a WebDB site that was earlier created through WebDB, you must use SQL*Plus to connect to target WebDB database and to manually delete the relevant schema objects and data items.
Three database schemas per site are created upon completion of the site installation procedure.
If the schema name chosen for the new WebDB site were MYSITE, then the relevant schemas would be:
MYSITE
MYSITE_PUBLIC
MYSITE_ADMIN
These schemas and the data associated with them must be deleted in
order to remove the site.
To drop websites created with WebDB's SiteBuilder, do the following in SQL*Plus:
- Log into SQL*Plus as user sys, with the appropriate password (default password is change_on_install).
For example: sqlplus sys/change_on_install
2. select username from all_users;
3. Look for the names of the sites you want to drop in the list of users.
For each <sitename>, you have the following users: <sitename> <sitename>_public <sitename>_admin 4. drop user <sitename> cascade; (This might take some time, about 10 minutes.)
5. drop user <sitename>_public cascade;
6. drop user <sitename>_admin cascade;
Repeat steps 3-6 for all the sites that you want to delete.
This drops your site, but leaves the link on the WebDB browser. To drop the link from the browser, you must run the following steps:
- Log into SQL*Plus as the "webdb" user.
- delete from wwv_modules$ where schema = upper('<sitename>'); (do this for each site you have dropped above)
- commit;
This now drops the Site link from the WebDB browser.
This procedure removes the site from the database and also removes the site link from the WebDB browser.
-- Regards, Joel Joel R. Kallman Oracle Service Industries Columbus, Ohio USA jkallman_at_us.oracle.com "Hans Biermans" <gd_at_tele.nl> wrote in message news:38B8FE6A.4A92EEE5_at_tele.nl...Received on Tue Feb 29 2000 - 03:30:30 CET
> Hi,
>
> Can someone suggest the way to delete one or more webdb sites.
> Thanks,
> Hans