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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Avoid the fragmentation in 9.2

Re: Avoid the fragmentation in 9.2

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 27 Feb 2005 06:59:51 +0100
Message-ID: <ibo221l74h9886tdbn3mq66sg0ea5fsklb@4ax.com>


On Sat, 26 Feb 2005 23:19:34 -0500, cschang <cschang_at_maxinter.net> wrote:

>We have a database in 9.2.0.5. Recently, we set up a procedure that
>will load about 1.5 millions records into a tmp table, drop a old table
> rename tmp to old and recreate the index on the old table. We have to
>do this weekly. How can we avoid to fragment the tablespace? Another
>DBA told me there is restriction of TRUNCATE table for million records
>even I use the drop storage option. IS that true? I have searched the
>manual and on-line, but no luck of such statement. Can any one give me
>hints how to do this more efficiently? Thanks
>
>C Chang

Locally managed tablespaces don't fragment. Period. What a DBA 'told' you is a fairy tale.
If you want to do more efficiently, ban 'temp' tables completely from your system. In Oracle you don't need them.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Feb 26 2005 - 23:59:51 CST

Original text of this message

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