Re: Use TOAD rebulid or perform table truncate & import?

I would go for this (if it is migrated rows)

Create a temp_table as select * from your table;

truncate the chained table

Insert into table select from temp_table;

Drop temp_table

The chained rows depend of the db_block_size and the length of the table's row and can happen only at INSERT time.

George.

"Glen A. Sromquist" <stromqgl_at_alpac.ca> wrote in message news:lNxn6.1427$go.76039_at_news0.telusplanet.net...
> I have 4 table(s) in a database that are showing a high number of chained
> rows, should I :
>
> -open the database in mount mode, export the table(s), truncate the table
 &
> import the data back in
> or
> -open the database in mount mode, use the TOAD rebuild table utility to
> build the script, and run the script?
>
> The latter seems like a lot simpler/faster process, but are there any
> potential pitfalls?
>
> What is the best method to determine the optimal PCTFREE for these tables
 to
> prevent this in the future?
>
>
> thanks in advance
>
>
Received on Fri Mar 02 2001 - 16:40:09 CST