Other than that pesky warning message about Product User Profile not loaded... ;)
- Kirti > -----Original Message----- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 04, 2001 3:35 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Droping System User > > > > Dropping the SYSTEM user is not really all that traumatic. > > In most cases it's just a DBA account that may own some pieces you'd > rather not lose, but dropping SYSTEM will not be noticed by the users > of the database. > > Jared > > > > > > > Jacques Kilchoer > > <Jacques.Kilchoer@ To: Multiple recipients > of list ORACLE-L <[EMAIL PROTECTED]> > quest.com> cc: > > Sent by: Subject: RE: Droping > System User > [EMAIL PROTECTED] > > > > > > 10/04/01 12:55 PM > > Please respond to > > ORACLE-L > > > > > > > > > > > -----Original Message----- > > From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] > > > > The best way to tell if this hurts is to create a test database for > > yourself, and try it. > > > > You may not get many experienced replies for this probably because the > > question is so far out of reality that nobody thought to try > > it. I would > > think that if anyone "accidently" did this to their own database, they > > quickly followed the command with a "Restore From Backup and Rebuild" > > command. > > > > > > OK, I viewed this statement from Mr. Mercadante as a challenge, so I tried > it. > I dropped user system, and was able to do a select (*) from dba_objects, a > create table, insert into the table, and commit. > > > I could also disconnect and reconnect to the database (though I did get > the > usual warning about Product_User_Profile being absent.) > > > What should I try to prove that my database is FUBAR? > > > SQL> connect jrk@sdjrk3 > Entrez le mot de passe : ******** > Connect�. > SQL> drop user system cascade ; > > > Utilisateur supprim�. > > > SQL> select count (*) from dba_objects ; > > > COUNT(*) > ---------- > 2942 > > > SQL> create table t (n number) ; > > > Table cr��e. > > > SQL> insert into t (n) values (1) ; > > > 1 ligne cr��e. > > > SQL> commit ; > > > Validation effectu�e. > > > SQL> disconnect > D�connect� de Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production > With the Partitioning option > JServer Release 8.1.7.1.1 - Production > SQL> connect jrk@sdjrk3 > Entrez le mot de passe : ******** > Erreur lors de l'acc�s � PRODUCT_USER_PROFILE > Attention : Informations du profil utilisateur du produit non charg�es! > Vous devrez peut-�tre ex�cuter PUPBLD.SQL en SYSTEM > Connect�. > SQL> select username from dba_users ; > > > USERNAME > ------------------------------ > SYS > OUTLN > DBSNMP > QUEST > JRK > A > > > 6 ligne(s) s�lectionn�e(s). > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
