Re: Striping Tables

From: Michael Serbanescu <mserban>
Date: 1996/11/26
Message-ID: <57dlbk$t5u_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1

This only way I can think of is to use the ALTER TABLE command as follows:

ALTER TABLE
ALLOCATE EXTENT
SIZE nnn[K|M]
DATAFILE <file_name>;

The ALLOCATE EXTENT clause lets you allocate an extent explicitly. I believe it became available with 7.1, maybe even 7.0, but I might be wrong. Try it and let me know if it did what you wanted.

I hope this helps.

Michael Serbanescu

---

leslie_at_darth.lfso.loral.com (Leslie Carter) wrote:
>
>I have a very large tablespace with about 40 existing tables all in 1
>datafile. These tables are heavily accessed, and I would like to split
>up the tablespace in 3 datafiles residing on different disks in order to
>increase performance. I plan to export the tables drop the tablespace.
>Recreate it with multiple data files. But how can I manage the
>placement of the tables in the different data files?
>
>I can use the alter database command and bring the datafiles offline to
>make them unavailable as the tables are imported, but I prefer to stripe
>the data, have each table spread across the datafiles.
>
>I saw how I could stripe data across the datafiles in the
>Administrator's Guide, but this would only work for 1 table per set of
>datafiles. That would be a major pain.
>
>Any ideas?
Received on Tue Nov 26 1996 - 00:00:00 CET