Re: WebDB: removing a site
Date: 2000/06/23
Message-ID: <3952F9D4.1DD3E6CE_at_loxinfo.co.th>#1/1
Same problem BUT:
I did the drop user My_Schema cascade;
as sys
there is no Record My_Schema in wwv_modules$
one record My_Schema WWV_SYS_COMPONENT_SCHEMAS$
I have in
Form Builder
Find an Existing Form
wwv_modules$ WWV_SYS_COMPONENT_SCHEMAS$ Find in Schema:
A
A
A
B
B
C
C
C
D
D
D
My_Schema
My_Schema
F
G
H
Now Im not sure If I just go and delete My_Schema in
WWV_SYS_COMPONENT_SCHEMAS$
There Is maybe an other Table linked.
Where are the entries F, G, H from at the Form Builder Find in Schema:
Field.
Any ideas......
Greg
Kirmo Uusitalo wrote:
> On Tue, 20 Jun 2000 15:03:05 GMT, arnie_at_krankikom.de (Arne Rudolph)
> wrote:
>
> >Hi!
> >
> >How do I remove a Site in the sitebuilder? I have one site that is
> >noch finished, but for some reason shows up in the sitebuilder menu as
> >"no name" and that doesn't belong to a schema ...
> >
> >But anyway I did not find any tool to drop an entire site ...
> >
> >Ciao,
> > Arne
>
> Hi,
>
> Below is the method I have succesfully used to drop a site:
>
> Regards,
>
> Kirmo Uusitalo
>
> On Fri, 24 Dec 1999 23:48:18 +0100, in comp.databases.oracle.tools
> "Leo Van Nieuwenhuyse" <leo.van.nieuwenhuyse_at_pandora.be> wrote:
>
> You must delete some entries in webdb.wwv_modules$ in the following
> way
>
> delete wwv_modules$
> where upper(name) = upper([sitename])
> and type_id = 40;
>
> You must also delete the schema's eventually made by webdb.
Received on Fri Jun 23 2000 - 00:00:00 CEST
