Re: Newbie - Tablespace defrag problem

From: Niall Litchfield <niall.litchfield_at_doial.pipex.com>
Date: 2000/07/21
Message-ID: <8l9p0e$roa$1@soap.pipex.net>#1/1

you can avoid this problem with the command line option compress=n on your export command. This should be the default option in my view.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Peter Larsen" <plarsen_at_dilbert.famlarsen.org> wrote in message
news:K9%c5.87$471.2678_at_skycache.prestige.net...



> > I export the tables, drop the tables & then run the alter tablespace

> > <tspace_name> coalesce command, and then import the tables back in -

> > The problem is that the 1st block of extents in the tablespace contain

> > freespace (The amount of blocks used varies within each tablespace)And

> > I can't seem to manage to get the import to use the 1st block of

> > freespace. Am I doing something stupid, or does Oracle do this for a

> > particular reason??

>

> Oracle makes use of the rule, that the whole initial extent must fit in

 one


> extent. When you export, the default action is that Oracle recalculates

> the initial extent based on the allocation of the table.

Received on Fri Jul 21 2000 - 00:00:00 CDT