Re: Moving a table to a different tablespace

In article <01bcd885$7c90ddd0$54110b87_at_clamagent>, Dan Clamage <clamage_at_mime.dw.lucent.com> wrote:
>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;

Yes, but this doesn't preserve indexes and constraints.

-- 

The Internet: an empirical test of the idea that a million monkeys banging
on a million keyboards can produce Shakespeare.