Xref: alice comp.databases.oracle.server:39577 Path: alice!news-feed.fnsi.net!netnews.com!feed1.news.rcn.net!rcn!cpk-news-hub1.bbnplanet.com!su-news-feed1.bbnplanet.com!news.gtei.net!inet16.us.oracle.com!not-for-mail From: Peter Sharman Newsgroups: comp.databases.oracle.server Subject: Re: How to reduce fragmentation in one TS? Date: Tue, 02 Feb 1999 09:20:17 -0800 Organization: Oracle Corporation Lines: 47 Message-ID: <36B733D1.657CC266@us.oracle.com> References: <7978ih$8o4$1@minus.oleane.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.5 [en] (WinNT; U) X-Accept-Language: en 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@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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~