Hi Michele and Moreno

If you are on Oracle10g export and import is not obsolete - slow, but
not obsolete :-)

For a faster alternative use datapump (only Oracle10g).

Over the years I've seen many wrong reasons for reorganzing tables -
but assuming you want to reclaim space left by deleted rows then
alter table .. shrink is the Oracle10g way to do it (inplace compaction).
This is also only for Oracle10g.

This requires your tables of interest to have row movement enabled - and
I don't know if SAP allows this with their rather strict policy about using
new database features before they have been thouroughly tested.

Do remember that reorganizing using export/import and datapump has
some nasty sideeffects if there are foreign key constraints to the tables
to be reorganized.


---- Message from Moreno.Ceretta@(protected) ------
>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
>
>
>
>

Med venlig hilsen
Martin Berg

mobil: +45 30 35 58 68
email: martin@(protected)
web: www.berg-consult.com

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