Re: Quick way to drop all objects in a schema
From: steve montgomerie <stmontgo_at_gmail.com>
Date: Thu, 19 Nov 2009 17:24:38 -0500
Message-ID: <5d4504220911191424v773b647fhef0f6395e254ca9c_at_mail.gmail.com>
We do a little of both where we drop tables and views through a cursor and then drop user cascade. I've found this to be about twice as fast as a simple drop user.
Date: Thu, 19 Nov 2009 17:24:38 -0500
Message-ID: <5d4504220911191424v773b647fhef0f6395e254ca9c_at_mail.gmail.com>
We do a little of both where we drop tables and views through a cursor and then drop user cascade. I've found this to be about twice as fast as a simple drop user.
It's peoplesoft so we have about 23,000 tables, 25,000 indexes. Takes about 45 mins for us.
Steve
On Thu, Nov 19, 2009 at 4: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-lReceived on Thu Nov 19 2009 - 16:24:38 CST