Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Moving a table to a different tablespace

Re: Moving a table to a different tablespace

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/10/14
Message-ID: <01bcd885$7c90ddd0$54110b87@clamagent>#1/1

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;

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US