Moving tables and indexes

From: (wrong string) ørn Sørensen <bjoesoe_at_online.no>
Date: Mon, 27 Nov 2000 01:52:12 +0100
Message-ID: <WhiU5.4296$5H3.117778_at_news1.oke.nextra.no>


[Quoted] 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 - 01:52:12 CET

Original text of this message