Re: How to "Defragment" Tablespaces ?

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:3AC473E9.49CD_at_yahoo.com...
> Sylvain Brun wrote:
> >
> > Hello,
> >
> > Got Oracle Server 7.3.4, and would like to defragment some
> > of my tablespaces.
> >
> > I tried to do this with "Tablespace Manager", but anything I
> > can do (connected as System, having all rights set on, with admin
> > option...),
> > the "defragment" button is always disabled !
> >
> > Please, explain me how to do, or tell me what is the SQL syntax for
 this.
> >
> > Thanks,
> >
> > Sylvain.
> >
> > --
> > =================================
> > Sylvain Brun -- Société INFOLOGIC
> > - Services et conseils en Informatique -
> > Tél. 04 75 82 16 40 - Fax. 04 75 82 16 38
> > =================================
>
>
> export / import
>
> and before you do this, work on a fixed extent size policy per
> tablespace, and you wont have to do the exercise again...
>
> hth
> connor
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"

If you have Perl and the DBI installed, try Perl module DDL::Oracle. It includes a complete defrag tool complete with automatic resizing of tables and indexes to either a buit-in algorithm or to one the user specifies. You won't need it with Oracle7, but it handles partitioned tables and indexes as well. DDL::Oracle is available from the CPAN, and from:

    http://sourceforge.net/projects/ddl-oracle/

Richard Sutherland
rvsutherland_at_yahoo.com Received on Fri Mar 30 2001 - 13:50:36 CST