From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Subject: Re: Moving Table in Tablespace
Date: 2000/04/04
Message-ID: <954876200.1778.3.nnrp-09.9e984b29@news.demon.co.uk>#1/1
X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41
References: <38E9E89A.5576F60@solsuni.pt>
X-Trace: news.demon.co.uk 954876200 nnrp-09:1778 NO-IDENT jlcomp.demon.co.uk:158.152.75.41
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: comp.databases.oracle.server
X-Complaints-To: abuse@demon.net



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@solsuni.pt>...
>
>What is the best mode of moving tables, with data, across Tablespaces ?
>
>Duarte Nuno de Sousa
>duarte.sousa@solsuni.pt
>
>