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: Transferring a table from one to another tablespace

Re: Transferring a table from one to another tablespace

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Mon, 12 Feb 2001 22:57:20 +0100
Message-ID: <969m4v$90v$01$1@news.t-online.com>

> As this question has a version specific answer, and you can't expect us to
> outline all the differences between the versions, please always include
 the
> version you are using.
> Indexes can be moved with alter index rebuild tablespace <new
> tablespacename>
>
> > Is it complicate to transfer a table which is stored on tablespace A to
> > tablespace B?
> >
> > Also the indexes from tablespace C to tablespace D?
> >

Sorry for forgetting that. I am usng 8.05 and 8.1.6.

Regards
Nicolas Received on Mon Feb 12 2001 - 15:57:20 CST

Original text of this message

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