Xref: alice comp.databases.oracle.server:39562
Path: alice!news-feed.fnsi.net!oleane!dial.oleane.com!not-for-mail
From: "Pierre-Yves Kerbiquet" <pkerbiqu@capgemini.fr>
Newsgroups: comp.databases.oracle.server
Subject: How to reduce fragmentation in one TS?
Date: Tue, 2 Feb 1999 17:23:45 +0100
Organization: Guest of OLEANE
Lines: 13
Message-ID: <7978ih$8o4$1@minus.oleane.net>
X-Trace: minus.oleane.net 917972369 8964 194.2.88.50 (2 Feb 1999 16:19:29 GMT)
X-Complaints-To: abuse@oleane.net
NNTP-Posting-Date: 2 Feb 1999 16:19:29 GMT
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4

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