Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How does move tablespace use MORE space not less
"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