Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How does move tablespace use MORE space not less

Re: How does move tablespace use MORE space not less

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 7 Feb 2006 17:41:06 +0100
Message-ID: <43e8cda3$0$27121$626a54ce@news.free.fr>

"zarleyman" <mrjohnpower_at_eircom.net> a écrit dans le message de news: 1139327430.438773.59820_at_g47g2000cwa.googlegroups.com...
| Hi,
| Can anyone explain how "alter table x move tablespace y" ended up using
| more space in table x than was the case before the move.
| I'm looking in dba_segments to see how much space is used.
| The reason I'm doing the move is to free up some space but for a
| minority of the tables, more space is used.
| Any explanations greatly appreciated.

|

Different storage parameters?

Regards
Michel Cadot Received on Tue Feb 07 2006 - 10:41:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US