Re: Moving tables...

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 20 Sep 1999 16:06:32 -0400
Message-ID: <fZPmN0WzxwHRlnPq0vSatYGskoL7@4ax.com>

A copy of this was sent to holdampf_at_mkb.hu (Zoltan Holdampf) (if that email address didn't require changing) On 20 Sep 99 19:47:42 GMT, you wrote:

>I'd like to know, is there any way to move a table from its tablespace
>to another without dropping and recreating it?
>
>
> regards, Zoltan Holdampf

Not until Oracle8i, release 8.1 when you can issue:

alter table T move tablespace X storage ( .... );

One of my favorite new commands in 8.1. Note that you have to rebuild indexes after such a move as well (rowids are different after the move).

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 20 1999 - 15:06:32 CDT