Re: Tablespace problem

In article dated 22 Jul 1996 00:43:23 GMT, Srinivasa Kunamneni (eleeb02_at_menudo.uh.edu) wrote:
> Steven Rorabaugh (dogbert_at_lamar.ColoState.EDU) wrote:

[fragmentation problem deleted ]

> 2) Export the table (with COMPRESS EXTENTS to Y, which is the default).
> Drop the tables and import the tables from the export file.

    2A) Export the tables
    2B) drop the tables
    2C) drop & recreate the tablespace
    2D) import the tables from the export file.

Step 2B is needed because V6 does not coalesce free space. I've spent many an hour doing this procedure.

Thankfully we recently laid V6 to rest in our shop.

> I hope it helps..

    Ditto

--
 _--_|\  John Verhoeven (johnv_at_acix.DIALix.oz.au or johnv_at_DIALix.oz.au)
/      \ >>>> Writing programs in assembler is like digging post <<<<
*_.--._/ >>>> holes with a teaspoon:  it takes a long time, but  <<<<
      v  >>>> you have complete control over all the dirt.       <<<<