OT : db reorg with alter table move 2006-10-27 - By michele.donna@(protected)
Back
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
|
|
