Re: Moving tables and indexes

Bjorn,

[Quoted] This stuff can be found in the Oracle manuals.

The syntax for moving an index is

    ALTER INDEX <index_name> REBUILD
    TABLESPACE <new_tablespace_name>
    STORAGE ... -- If desired

Depending on the version of Oracle, you can move tables in different manners. Prior to 8i (I believe) you can move tables by performing an export and import of the data. With 8i, you can issue the ALTER TABLE <table_name> MOVE statement. I am not sure of the syntax, but I do know it is possible.

Dave Grzebien
Expert Technical Consultants, Inc
dave_at_etci.net

"Bjørn Sørensen" wrote:

> Can somebody tell me how I can move tables and indexes from one tablespace
> to another ?
> The problem is :
> I want to move one big table to a new tablespace and the database indexes to
> a second new tablespace.
> How do I do this and will the indexes be rebuilt after moving them ? If not,
> how can this be done ?
>
> Any help would be great. Thanks
>
> bjorn
> bjoesoe_at_online.no
Received on Mon Nov 27 2000 - 03:59:06 CET