Re: Oracle Options

  • From: mkb <mkb125@xxxxxxxxx>
  • To: bunjibry@xxxxxxxxx
  • Date: Wed, 18 May 2005 07:58:13 -0700 (PDT)

Yes, that should work for most of the installed
options except partitioning since that does not have a
corresponding user.

One note, I have done this on HP-UX 11i, 9.2.0.1 with
drop user MDSYS cascade..., and it did hang, not the
database, just the drop.  I was able to drop all the
other users cleanly.  There might be a sequence in
dropping these.  Just an FYI.

--
mohammed

--- Bryan Wells <bunjibry@xxxxxxxxx> wrote:
> sorry. lack of information on my part. i inherited
> these, as they were 
> turned on at the original install time. 
>  so its not just a matter of dropping the user
> ("cascade") that was created 
> at the time of install?
>  On 5/18/05, Thomas Day <tomday2@xxxxxxxxx> wrote: 
> > 
> > Don't install them. There is no "turn them on/turn
> them off" option.
> > --
> > //www.freelists.org/webpage/oracle-l
> > 
> 
> 
> 
> -- 
> Bryan S Wells - DBA Newbie
> bunjibry@xxxxxxxxx
> 
> --
> //www.freelists.org/webpage/oracle-l
> 


                
__________________________________ 
Yahoo! Mail Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 
--
//www.freelists.org/webpage/oracle-l

Other related posts: