Re: Table Fermentation

no-spam wrote:

> Hi
>
> I have a table space with about 63 tables in it. Most of the tables
> are less than 100k rows.
>
> If I wanted to defrag the tablespace, can I export and import one
> table at a time or do I have to export all the tables in one go and
> import back in again
>
> I do not want to use the compress=y option
>
> Are there additional command I have to issue re the table_space ?
>
> Thanks

Is this: Guess what version I'm using day?

And what do you mean by "not wanting to use" an option? Do you want us to guess why too?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)