RE: Oracle cursor help
- From: jobmiller@xxxxxxxxx (Job Miller)
- Date: Mon, 27 Jun 2005 11:20:28 -0700 (PDT)
What seemed to work well was this: select the rows I
want to keep into a new table; truncate the old table;
drop the old table; rename the new table to the old;
redo indices, etc. The part that surprised me was the
truncate. Simply dropping a table without first
truncating it seemed to take a lot longer.
------------
Assuming being unavailable for that time is okay this
seems acceptable. does hammering=using?
row by row deletes with intermittent commits is more
work overall(redo and otherwise included).
did you suggest the partitioning approach based on
purge mentality?
Job
--- "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx> wrote:
> Yes. A TRUNCATE operation is a data dictionary
> reset of the table's storage to the initial size
> (the high-water mark). This operation is
> unrecoverable and does not involve redo, rollback,
> index operations, trigger firing, etc. All of this
> is covered to some degree in the concepts manual for
> your specific version.
>
> -----------------
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
>
> -----Original Message-----
> From: Steve Sapovits [mailto:steves06@xxxxxxxxxxx]
> Sent: Monday, June 27, 2005 10:30 AM
> To: Reidy, Ron
> Cc: dbi-users@xxxxxxxx
> Subject: Re: Oracle cursor help
>
>
> Reidy, Ron wrote:
>
> > Why don't you speak with the DBAs at your site?
> They can tell you
> > what they want, and if it goes south, they will
> have themselves
> > to blame.
>
> We have some ongoing dialogue. Mostly they want me
> to stop
> hammering their database. ;-)
>
> What seemed to work well was this: select the rows
> I want to
> keep into a new table; truncate the old table; drop
> the old
> table; rename the new table to the old; redo
> indices, etc. The
> part that surprised me was the truncate. Simply
> dropping a
> table without first truncating it seemed to take a
> lot longer.
>
> --
> Steve Sapovits steves06@xxxxxxxxxxx
>
> This electronic message transmission is a PRIVATE
> communication which contains
> information which may be confidential or privileged.
> The information is intended
> to be for the use of the individual or entity named
> above. If you are not the
> intended recipient, please be aware that any
> disclosure, copying, distribution
> or use of the contents of this information is
> prohibited. Please notify the
> sender of the delivery error by replying to this
> message, or notify us by
> telephone (877-633-2436, ext. 0), and then delete it
> from your system.
>
>
____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com
.
- References:
- RE: Oracle cursor help
- From: Ron Reidy
- RE: Oracle cursor help
- Prev by Date: RE: Oracle cursor help
- Next by Date: RE: DBD::ODBC, unixODBC, FreeTDS, MS-SQL, lazy DL,dbd_db_login/SQLSetConnectOption err=-2
- Previous by thread: RE: Oracle cursor help
- Next by thread: ODBC and tables 'v' views
- Index(es):
Relevant Pages
|
|
