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