Re: Moving table to another tablespace

From: <hhyde_at_my-dejanews.com>
Date: Wed, 29 Jul 1998 18:30:50 GMT
Message-ID: <6pnpoq$89e$1@nnrp1.dejanews.com>

Have you tried:

CREATE TABLE New_Table
AS SELECT * FROM Existing_Table
TABLESPACE New_Tablespace ;

Hope this helps.

In article <35bcaaa3.10192696_at_news2.mm.com>, johng_at_nospam.mm.com wrote:
> Hi,
> What is the best way to move a table ( or several tables) from one
> tablespace to another? I would like to avoid the obvious - creating
> the table structure in the new tablespace with a different name, and
> using 'insert into....' statements to populate it with the data from
> the original table, dropping the original and renaming the new one....
>
> Any other way?
>
> Thanks,
> John Greco
> System : Oracle 7.3, Netware 4.11
>
> Reply here or email to : john.greco_at_dot.state.mn.us
>
> Thanks....
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 13:30:50 CDT