Re: Quick way to drop all objects in a schema

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 19 Nov 2009 12:31:49 -0800
Message-ID: <bf46380911191231n4213248ah61e7f19c88cf40d9_at_mail.gmail.com>

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_at_sefas.com> wrote:

> Is there a quick way to drop all objects in a schema without dropping the
> user itself?
>
> This is with Oracle 10.
>
>
>
> **
>

--
http://www.freelists.org/webpage/oracle-l




application/octet-stream attachment: clear_for_spool.sql



application/octet-stream attachment: clears.sql



application/octet-stream attachment: dup_user.sql



application/octet-stream attachment: java_privs.sql

Received on Thu Nov 19 2009 - 14:31:49 CST