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

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving tables to different tablespaces

Re: Moving tables to different tablespaces

From: Kluged <kluged_at_ix.netcom.com>
Date: 1997/10/06
Message-ID: <3439D11F.7E35@ix.netcom.com>#1/1 







you could create a copy of the existing table using a different name in
the new tablespace, insert into the table as a select from the existing
table, drop the old table, then rename the new one.



S Metro wrote:


> 

> Is there anyway to move a table from one tablespace to another without

> dropping the table and recreating it?

> 

> Thanks...

> 

> Scott Metro

> (take out nospam for email replies)

Received on Mon Oct 06 1997 - 00:00:00 CDT












Original text of this message













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