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!!!
Received on Fri Sep 10 2004 - 10:59:16 CDT
