Re: Striping Tables

From: Strategic Data Systems <sds_at_dataplusnet.com>
Date: 1996/11/26
Message-ID: <57fjir$crg$1_at_news.inc.net>#1/1


In article <57cgc5$lr8_at_news.lfso.loral.com>, leslie_at_darth.lfso.loral.com! says...
>
>
>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?

Wouldn't it be easier for the OS to do the striping? Received on Tue Nov 26 1996 - 00:00:00 CET

Original text of this message