Re: Tablespaces
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 06 Dec 2011 19:33:32 +1100
Message-ID: <jbkk0s$mpo$1_at_dont-email.me>
ExecMan wrote,on my timestamp of 2/12/2011 8:45 AM:
Date: Tue, 06 Dec 2011 19:33:32 +1100
Message-ID: <jbkk0s$mpo$1_at_dont-email.me>
ExecMan wrote,on my timestamp of 2/12/2011 8:45 AM:
>
> Good article. Very helpful. What does a command like this do?
>
> alter table SHOPCART_SESSIONS move;
>
> It runs, but what does it do to the table? Rebuild it?
It moves it into the same tablespace. IOW: it recompacts the table into the first available free space in the original tablespace. Received on Tue Dec 06 2011 - 02:33:32 CST