Re: how can i delete WebDB site

From: Joel R. Kallman <jkallman_at_us.oracle.com>
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:

  1. 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:

  1. Log into SQL*Plus as the "webdb" user.
  2. delete from wwv_modules$ where schema = upper('<sitename>'); (do this for each site you have dropped above)
  3. 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...

> Hi,
>
> Can someone suggest the way to delete one or more webdb sites.
> Thanks,
> Hans
Received on Tue Feb 29 2000 - 03:30:30 CET

Original text of this message