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