Re: Moving TABLES to another TABLESPACE

DavidJRoth (davidjroth_at_aol.com) wrote:
: There is no way to MOVE a table from one tablespace to another, but it is
: easy to make a COPY and then delete the original.
 

: Try;
 

: RENAME tablename to tmpname;
 

: CREATE TABLE tablename
: AS SELECT * FROM tmpname
: tablespace new_tablespace;
 

: DROP table tmpname;

problem:

rename will also transfer the integrity constraints which might reference your original table to the temporary table. The create table ... as select .... will not create constraints also.
You will have to drop all constraints which reference the original table first, then recreate them for the new table.

Steve Laverack, BT, Ipswich Received on Tue Jan 24 1995 - 10:02:44 CET