Re: Moving a table to a different tablespace

>>CREATE TABLE new_tspace.new_table AS SELECT * FROM old_tspace.old_table
this will recreate the table under a new schema, not necessarily a new tablespace. If the default tablespace for both users are the same, you're out of luck. The quickest way and at the same time you can compress the extents is to export then import. You will have to change the default tablespace for that user before the import.

Cheers, Robert Prendin

"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;
 

>- 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 Wed Oct 15 1997 - 00:00:00 CDT