Originally posted by BV1963
I beleive in your previous postings u said you are using RAID5. That means wheather you have 1 extent or many , they will be spread out on a different drives . You will waste you time doing this export and import or in fact using any other thechniques. If you have 1 or 100 extents, WHO CARES! Even 1 extent is not contigious on a disks, besides how ofter (if ever) do you run compress utility on a disk ?

Regards
Can you please explain it a little more clearly.

Also according to you guys I should do a full export, drop schemas , coalesce tablespaces and do the import. Is that all or something else.

What should i do with my system tablespace being so fragmented.

I can create a new Db with the same sid on some other machine, recreate the tablespaces and do the full import., that will fix the problem. But how do i make sure that system table fragmantation does not happen again. How do i determine my storage parameters to fix this.

Thanks


[Edited by ronnie on 04-28-2002 at 01:00 PM]