Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!infonode!dalmandm
From: dalmandm@infonode.ingr.com (Dianne M. Dalman)
Newsgroups: comp.databases
Subject: ORACLE question
Keywords: first post!
Message-ID: <1991Feb14.163452.28616@infonode.ingr.com>
Date: 14 Feb 91 16:34:52 GMT
Distribution: comp
Organization: Intergraph Corp. Huntsville, AL
Lines: 36

(Please excuse any glaring errors here, this is my first post!)

Question:  In oracle, is there any "quick and dirty" way to delete a user,
and drop all tables owned by that user?  I haven't been able to find anything
in documentation about how to get rid of an oracle username once it's been
created, and it's a hassle to have to go into the system tables to find
out all the tables which have been created by a user, drop them one by one,
and then just leave that "empty name" hanging out there.  Seems messy!

(previously I used standard engine INFORMIX, where a simple "rm -r" solves
all problems!)

------ (new subject) ------
My (very modest) opinions on various databases: (no flames, please, I'm 
relatively new at this!)

Informix SE:  small, quick, friendly, a perfect "one user-one database" RDBMS
Informix -ONLINE:  Larger (min. 125K blocks), copied ORACLE's "one main db
	for everyone" concept to be competative in that market.  Relatively
	new but fairly stable, STILL friendly (isql menus, etc.) and quick.
Oracle:  spacehog, slow, but better than most at networking, somewhat
	    UN-friendly (a programmers database, not for the low-end user) since
	    it needs to be "tuned" and you need to know your SQL .  Better
	    (more flexible) report writing capabilities than INFORMIX.
	    more portable. a good large "production " remote database.
Ingres:  (not too much experience here)  large, moderately friendly. (??)

---------------------------------------------------------------------
Disclamer:  Opinions expressed herein are Strictly my own, and are
	subject to change at my slightest whim, with no forewarning whatsoever
	unless it's tuesday and the moon is full and my shoes are on 
	backwards...i.e. Opinions are nearly as stable as a first release
	of a brand new RDBMS based on previously untested relational theories...
-----------------------------------------------------------------------
Opinion, comments, answers >> uucp!ingr!wyle!dianne!dianne
gripes, flames >>/dev/null