Newbie - Tablespace defrag problem

From: <barry_deevey_at_my-deja.com>
Date: 2000/07/18
Message-ID: <8l1462$969$1@nnrp1.deja.com>#1/1

Hi,
I have a requirement to de-fragment the tables & tablespaces within my database.

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??

Any help or advice will be greatly appreciated.

Many Thanks,
Barry.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 18 2000 - 00:00:00 CDT