Re: Quick way to drop all objects in a schema
- From: Jared Still <jkstill@xxxxxxxxx>
- To: JDunn@xxxxxxxxx
- Date: Thu, 19 Nov 2009 12:31:49 -0800
I tend to look at this much the same as deleting a large number
of rows from a table - it's much more efficient to create a table
with the wanted rows, drop the old table and rename the new one.
By the same token, it is much easier to just drop the account
and recreate it.
The attached script dup_user.sql will generate a script that is used
to recreate an account.
clears.sql and clear_for_spool.sql are just supporting scripts.
One thing that dup_user.sql does not do is deal with Java privs.
The attached script java_privs.sql will display the Java privs.
Or should you feel like updating dup_user.sql ...
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Thu, Nov 19, 2009 at 1:25 AM, John Dunn <JDunn@xxxxxxxxx> wrote:
> Is there a quick way to drop all objects in a schema without dropping the
> user itself?
>
> This is with Oracle 10.
>
>
>
> **
>
Other related posts:
