Re: Moving a table to a different tablespace

All this will do is create under a different schema. What you should do is export, drop the table, re-create it in the new tablespace and import.
then check the owner it was created under has the right default tablespace. (It is also possible to export, drop table, alter default TS and import).

Nick

The message <jB91.12$f4.113757_at_NewsRead.Toronto.iSTAR.net>   from rprendin_at_magi.com (Robert) contains these words:

> >>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 Mon Oct 20 1997 - 00:00:00 CDT