Re: How to reduce fragmentation in one TS?

Hi,

  Do you mean you want some commands like :

  ALTER TABLESPACE xxx COALESCE;

Is that what you want ?

John K.

Peter Sharman wrote in message <36B733D1.657CC266_at_us.oracle.com>...
>Pierre-Yves
>
>Yes it will probably cause fragmentation if you are adding mandatory
>columns, maybe not if you're adding nullable ones (depends on the amount
>of data going in). Yes, export/import will remove the fragmentation but
>NO, compress=y is not necessary. This is a common misconception. All
>this will do is put the entire object in one extent (a humongous one
>probably in your case).
>
>HTH.
>
>Pete
>
>Pierre-Yves Kerbiquet wrote:
>
>> Hello,
>>
>> I am adding columns to a large table (billion of rows). I am afraid it
>> creates fragmentation.
>> Can I reduce fragmentation by doing export/import of this table?
>> Do I need to specify COMPRESS=Y when exporting data?
>> Do you have a tip to view fragmentation in one TS?
>>
>> Thank you for your help.
>>
>> PYK
>
>--
>
>
>Regards
>
>Pete
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Peter Sharman Email: psharman_at_us.oracle.com
>WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
>Worldwide Internal Services Education (650)607 0109 (local)
>San Francisco
>
>"Controlling application developers is like herding cats."
>Kevin Loney, ORACLE DBA Handbook
>"Oh no it's not! It's much harder than that!"
>Bruce Pihlamae, long term ORACLE DBA
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
Received on Wed Feb 03 1999 - 01:31:37 CST