Striping Tables
Date: 1996/11/25
Message-ID: <57cgc5$lr8_at_news.lfso.loral.com>#1/1
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 Mon Nov 25 1996 - 00:00:00 CET