> -----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).
