Re: delete a complete schema

From: MarkP28665 <markp28665_at_aol.com>
Date: 1998/03/17
Message-ID: <1998031722554601.RAA19542@ladder03.news.aol.com>#1/1

From: svenkunze_at_aol.com (Sven Kunze) >> Asked how to delete a user.

From sqlplus or svrmgrl:
If user has no objects or the objects are dropped first then: drop user user_name;

If the user has objects and you do not want to drop them first: drop user user_name cascade delete;

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Tue Mar 17 1998 - 00:00:00 CST