Re: Oracle Striping

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 28 Jun 1999 09:15:00 -0700
Message-ID: <37779F84.2D4F9782@us.oracle.com>

Doug

Same way you did it in earlier versions.

What? You want more?

Sorry, I'm in an ironic mood this morning! Are you talking specifics of partitioning, or just a straight table? If it's a normal table, all you need to do is create the tablespace for the table with 4 separate datafiles, one on each drive. Then create the table with initial slightly smaller than the datafile size, minextents set to 4 and voila! Of course, the data won't really be striped until all four extents are loaded.

Now, if you want the table partitioned, create four separate tablespaces, one on each drive, then point each partition to a separate tablespace and voila again!

HTH. Pete

Doug Cowles wrote:

> How do I spread a table across 4 drives in Oracle 8?
>
> - Dc.

Regards

Pete

Received on Mon Jun 28 1999 - 11:15:00 CDT