Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> how to clear a schema without dropping the user?
I need to give a schema owner the effect of 'drop user sch_owning_user
cascade' without him having dba priviledge. That is, I want to keep the
user's acocunt/password, tablespace etc, but need to clead all tables,
packages, sequences, etc. Short of getting a list of objects from obj view,
is there a simple way?
Kenny Received on Tue Oct 22 2002 - 12:46:52 CDT