Normally when one is creating a table in a striped tablespace one can,
with a little trouble, force extent allocation in a round-robin
fashion. I never do things the easy way :-); what I want to do (in an
8.1.7.4.1 db) is create a striped tablespace and do an 'alter table
move' and get somewhat balanced extent allocation over four datafiles;
more important, get balanced allocation going forward.
I am trying to do this with some (hash-)partitioned tables and some
non-partitioned.
I have yet to devise a reasonable way to do this. I've come up with
some schemes - e.g., setting the striped tablespace just slightly
larger than the table, moving it, then setting datafiles to autoextend
- but they always have the flaw of getting round-robin allocation
afterwards. Unfortunately this is a production, third-party
application so a programmatic change for inserts is out of the
question.
If anyone has done this, or can point me in a useful direction for
further reading or research, I would be grateful.
TIA -
Best regards,
jh
Received on Mon Jul 21 2003 - 18:35:49 CEST