Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delete whole table in one go versus batches

Re: Delete whole table in one go versus batches

From: Tom Best <oracle_person_at_yahoo.com>
Date: Tue, 20 Aug 2002 09:52:48 -0400
Message-ID: <ajtdor$b82$1@news.bentley.com>


Ender:

How about writing a stored proc (which is owned by a user having the drop any table priv) that does the truncate, and the DBA grants you execute to that stored proc?

HTH,
Tom Best

"Ender Wiggin" <ender_wiggin29plus1_at_yahoo.com> wrote in message news:PXi89.557$JR1.72798_at_newsfeed.slurp.net...
> Coughs, not the owner of the table, access is given to
> insert/select/update/delete for the table. So unless my
> dear DBA grants me to drop any table, I am kind of stuck...
>
>
> Richard Foote wrote:
>
> > Hi Ender,
> >
> > Love to hear what those various reasons are ...
> >
> > Love to hear just one.
> >
> > Richard
> >
> > Ender Wiggin wrote:
> >>
> >> Are there any performance gains to delete rows in batches versus one
> >> delete statement if I don't cause the rollback segments extend ? Thnx
> >>
> >> Rows > .5 million
> >>
> >> PS> Cannot use truncate for various reasons...
>
Received on Tue Aug 20 2002 - 08:52:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US