Re: Moving TABLES to another TABLESPACE

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;

Dave Roth
Carty Mailloux Consulting
(508)392-1300 Received on Sun Jan 22 1995 - 15:55:09 CET