Re: Moving a table to a different tablespace

Mr.djc,

I believe he is talking about moving to different tablespace and NOT different schema.

Chinna

Dan Clamage <clamage_at_mime.dw.lucent.com> wrote in article <01bcd885$7c90ddd0$54110b87_at_clamagent>...
> 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 Fri Oct 17 1997 - 00:00:00 CDT