Re: Move a table from one tablespace to another

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 15 Nov 1999 10:19:25 -0500
Message-ID: <ISQwOHn6biMA0tZtS5rPfTxxS+pC@4ax.com>

A copy of this was sent to Frederik Hansen <roirex_at_post1.tele.dk> (if that email address didn't require changing) On Mon, 15 Nov 1999 16:15:13 +0100, you wrote:

>Hi
>
>Is this possible without doing a exp/imp?
>
>Frederik Hansen

Prior to Oracle8i release 8.1, you have to typically move the table out of the database and then reload it (or CREATE TABLE AS SELECT, DROP OLD_TABLE, RENAME NEW_TABLE -- add indexes, etc, etc, etc).

In Oracle8i, release 8.1 you can:

SQL> alter table X move tablespace Y;

And then rebuild the indexes on the table. No need to exp/imp.

--
See http://osi.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 Nov 15 1999 - 09:19:25 CST