Re: Moving a table to a different tablespace

Shakespeare, this ain't.
Given the necessary permissions, you can create the new table by selecting from the old:
CREATE TABLE new_tspace.new_table AS SELECT * FROM old_tspace.old_table;

• djc

Cheng-Jih Chen <cjc_at_interport.net> wrote in article <61ts7v$4a4$1_at_interport.net>...
> I'd like to move a table from one tablespace to another.
> Is there any easy way to do this, or will I have to export
> the table, drop it, and then import it?
> The Internet: an empirical test of the idea that a million monkeys
 banging
> on a million keyboards can produce Shakespeare.
But it'll take a million years. Received on Tue Oct 14 1997 - 00:00:00 CDT