Hi Michele,
I hope that You have some Partitioned table so you can move only one partition!
I work with large DataWare House and usually I use move table partitioned table

an other way to do that is using Import/Esport but is Obsolete.
Remember Double size of Table data and Indexes!
Bye
Moreno


Scrive michele.donna@(protected):

> Hello all,
>
> Sorry for this generic question but as I'v seen there are a lot of users
> with very large databases here ;)
>
> I'm going to reorganize a 2TB SAP database, our oracle consultant told us to
> use alter table move statements; we performed some tests and it's very
> fast..
>
> BUT we're going to keep tables in existing tablespaces so we need al least
> the double size of a table to have the move statement work correcly..and
> that's a waste of space in my opinion.
>
> another solution is to create a "temporary" tablespace and moving there and
> then back the table..but it's time consuming...
>
> anyone has a suggestion on how to optimize the reorg ?
>
> Many thanks to all and best regards !
> Michele
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>
>
>


#############################################
Moreno Ceretta
Engineering - Ingegneria Informatica S.p.A
email: moreno.ceretta@(protected)
Mobile: +39 348 4908388
#############################################

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting