Re: Moving tables from one tablespace to another

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 14 Jul 2004 18:16:55 -0700
Message-ID: <1089854233.803782@yasure>

John A. Horve wrote:

> Hello,
>
> Is it possible to move tables from one tablespace to another tablespace?
>
> If so, does anyone have the SQL for this operation ?
>
> Regards John

I don't normally do this but you've earned it: RTFM!

That said go to http://www.psoug.org
Click on Morgan's Library
Click on Tables
Search for "Move Table To A Different Tablespace"

Daniel Morgan Received on Wed Jul 14 2004 - 20:16:55 CDT

This message: [ Message body ]
Next message: Daniel Morgan: "Re: update table a.fkid from table b.pkid, additional information"
Previous message: Daniel Morgan: "Re: help with xmltype column larger than 4000 bytes"
In reply to: John A. Horve: "Moving tables from one tablespace to another"
Next in thread: Bagieta: "Re: Moving tables from one tablespace to another"
Reply: Bagieta: "Re: Moving tables from one tablespace to another"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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