Re: object # of extents

>
> There in lies the problem. We are still using DMTs. If should go to
> reorg the tables that have over 4 or 8000 extents, would it be best to
> exp/truncate/imp or alter table move?
>

You should really consider converting to LMTs. There are too many benefits and I cannot think of a single reason not to do the conversion.

So I'd create a new tablespace and make this tablespace LMT. Then, I'd move the table in to this new tablespace with the ALTER TABLE MOVE command. There are a few restrictions on this operation (i.e. you cannot move a table that contains a LONG or LONG RAW column). So if the restrictions stop you from using the ALTER TABLE MOVE command, use export/import.

HTH,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown