Re: Moving TABLES to another TABLESPACE

From: sreedhar annamalai <sreedhar_at_world.std.com>
Date: Fri, 27 Jan 1995 16:37:22 GMT
Message-ID: <D32ouB.LD3_at_world.std.com>

---

The following does not work if there are long data types. Any other suggestion?

sreedhar_at_world.std.com

---

davidjroth_at_aol.com (DavidJRoth) writes:

>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 Fri Jan 27 1995 - 17:37:22 CET