Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Example schemas: How to drop???
goshengoogle_at_yahoo.com (David) wrote in message news:<c6a42c32.0409100759.4ac81f0_at_posting.google.com>...
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1094786056.889092_at_yasure>...
> > David wrote:
> >
> > > Help!!! I can not drop the example schemas, that is, the schemas that
> > > begin with "QS" (QS, QS_ADM, etc.). This is required to meet the
> > > security needs of an external organization.
> > >
> > > Here is what I have tried:
> > >
> > > - 'drop user cascade' statement did not work even after unlocking the
> > > accounts. Received 'end-of-file communications channel' error from
> > > Oracle and then was disconnected.
> > >
> > > - Tried building my database instance with a template and in the
> > > template set 'Example Schemas' to 'false'. This did not work; the
> > > 'QS' schemas were still created.
> > >
> > > - Could not delete the schemas with the Enterprise manager console
> > > even after unlocking the accounts.
> > >
> > > - Could not determine the passwords for any of these accounts. For
> > > example I see in lots of places that QS_ADM account has a password of
> > > QS_ADM, but this did not work. Whem I looked at the schema creation
> > > scripts in the Oracle 'demo' directory, appears that all of the 'QS'
> > > schemas have the same password. But what is it?
> >
> > this must be the week for people that don't really want help.
> >
> > Oracle version? Unimportant?
> > Operating system? Unimportant?
> > Error message? Unimportant?
> > Getting help? Unimporant?
> >
> > My guess ... you have an aq job running.
> > You must stop the job before you can drop the schema
> > Of course we'd know whether that was correct or not if you
> > hadn't thought error messages unimportant to post.
>
> I do not usually respond to sarcasm. But I'll make an exception. Ok,
> I forgot to list certain features of my system, but is that any reason
> to be a s.o.b? If you can't say something nice, keep your mouth shut
> and mind your own business!!!
You should monitor or google a group before posting. Here is a howto for this group: http://members.cox.net/oracleunix/readme-cdos.htm
jg
-- @home.com is bogus. http://www.icm-corp.com/showcase1.htmReceived on Fri Sep 10 2004 - 19:24:44 CDT