Re: Table Fermentation

From: Ryan <rgaffuri_at_cox.net>
Date: Fri, 5 Dec 2003 18:24:46 -0500
Message-ID: <Cs8Ab.43939$yM6.4009@lakeread06>

its easier to create another tablespace. do alter table move. move all the tables over to the new instance. save the index definitions in a table.

if you want to keep the same tablespace name: all you need is uniqueness, table name, index name, primary key or unique constraint, type

move the tables back. use the stored index data to recreate the indexes. you can do this in parallel with dbms_job. done it. your better off switching to a locally managed tablespace when you move back. you will never have fragmentationt hen.
"no-spam !@!bhfshops.org.uk" <rc@!> wrote in message news:3fd0770c.863429005_at_news.demon.co.uk...
> 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
>
>
>
Received on Fri Dec 05 2003 - 17:24:46 CST