From cspence@FuelSpot.com Thu, 04 Oct 2001 12:51:33 -0700 From: Christopher Spence Date: Thu, 04 Oct 2001 12:51:33 -0700 Subject: RE: Droping System User In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Droping System User The DBA_ tables are owned by SYS.   But a lot of features such as AQ and such use objects owned by SYSTEM.   "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863   -----Original Message----- From: Jacques Kilchoer [mailto:Jacques.Kilchoer@quest.com] Sent: Thursday, October 04, 2001 3:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Droping System User   > -----Original Message----- > From: Mercadante, Thomas F [mailto:NDATFM@labor.state.ny.us] > > 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).