Re: Moving objects to different tablespaces

From: Allen <allenh_at_starbase.neosoft.com>
Date: 8 Dec 2000 15:32:33 -0600
Message-ID: <3632D131D7C580C7.334EDF88F7B7B401.C652F5213674633B@lp.airnews.net>

>In Oracle 8i you have the 'alter table ..... move' command which
>foregoes the need for the temporary table. It also allows you
>to specify new storage parameters if you wish.
>
>In either version the index is handled the same way --
> alter index <indexname> rebuild
>and you can add storage parameters as needed.

Hi Roy,

Many thanks for the info! Can I get exact syntax examples on these two commands? I couldn't find them anywhere.

Allen Received on Fri Dec 08 2000 - 15:32:33 CST