Re: Move table to another tablespace

From: <satar_at_my-dejanews.com>
Date: Wed, 11 Nov 1998 23:23:41 GMT
Message-ID: <72d69t$i48$1@nnrp1.dejanews.com>

How about the following?

CREATE TABLE schema.sometable TABLESPACE tablespace2 AS select * from tablespace1.sometable;

Good Luck,
Satar

In article <364762e6.231624_at_news.a2000.nl>, pantah_at_speed.a2000.nl (Jan Dolman) wrote:
> How can I move a table form one tablespace to another?
>
> I cannot find any SQL command that does so. The only method I can
> think of is to copy the table to a new one (using CREATE TABLE COPY
> AS SELECT * FROM ORIGINAL), dropping the original table, and then
> creating the original table again in the correct tablespace by using
> CREATE TABLE ORIGINAL. AS SELECT * FROM COPY again.
> Surely this cannot be the only way??
>
> Please help.
> Jan
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 11 1998 - 17:23:41 CST