PUBLIC:Re: fragmentation

Jerry Gitomer wrote:

<snip>

> First to correct the problem:
>
> 1. Use export/import to create a script with the DDL
> needed to rebuild the tables in the tablespace.
>
> 2. Edit the script changing the initial and next values
> for each table so that the initial extent will hold
> the entire table.

If you have the compress=y during export, step 1 and 2 are obsolet.

>
> 3. Export the tables
>
> 4. Drop each of the tables
>
> 5. Run the script that you edited in step 2
>
> 6. Import the data (you have to set import to ignore the
> error resulting from the fact that your tables already
> exist).

A drop of tables means drop, so that they doesn't exist any longer (if you use truncate instade, point 6 is correct), and you wan't get any errors regading existing tables and index (also drop during table drop). Asumeing that you have all tables drop, which will be imported.

<snip>

eugen Received on Fri Jan 23 1998 - 00:00:00 CET