Re: Avoid the fragmentation in 9.2

cschang 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

The first problem is that you claim you "have to do this": You don't.

Instead of posting your assumed solution ... try posting the business problem. I have not once had to do this and you don't either.

Oh and fire the DBA ... the DBA is totally clueless.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)