Re: Quick way to drop all objects in a schema
- From: steve montgomerie <stmontgo@xxxxxxxxx>
- To: JDunn@xxxxxxxxx
- Date: Thu, 19 Nov 2009 17:24:38 -0500
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@xxxxxxxxx> wrote:
> Is there a quick way to drop all objects in a schema without dropping the
> user itself?
>
> This is with Oracle 10.
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
