Get 8.1 and use 'alter table XXX move tablespace YYY';
Then 'alter index xxx_pk rebuild tablespace zzz' etc.
The nologging option will make it faster but may not
be appropriate.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Duarte Nuno Sousa wrote in message <38E9E89A.5576F60_at_solsuni.pt>...
>
>What is the best mode of moving tables, with data, across Tablespaces ?
>
>Duarte Nuno de Sousa
>duarte.sousa_at_solsuni.pt
>
>
Received on Tue Apr 04 2000 - 00:00:00 CDT
