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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 12 Feb 2001 21:45:48 +0100
Message-ID: <t8gio36tbcpi35@beta-news.demon.nl>

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>

Hth,

Sybrand Bakker, Oracle DBA

"Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message news:969hbn$bdd$00$1_at_news.t-online.com...
> 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?
>
> Thanks in advance
>
> regards
> Nicolas
>
>
>
>
Received on Mon Feb 12 2001 - 14:45:48 CST

Original text of this message

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