Re: Oracle Striping

Oh...the same way!! Hehe.. No really..that's what I suspected, I just wanted to be sure. Actually, I'm curious about creating the intial extent slightly smaller than the datafile size. Let's say I create it a lot smaller, will Oracle round robin it for me across the four drives and spread things out, or does it have to be just one big extent in each datafile..

Thanks...
Dc..

Pete Sharman wrote:

> 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
>
> ------------------------------------------------------------------------
>
> Pete Sharman <psharman_at_us.oracle.com>
> Project Manager
> Worldwide Internal Services Education
> Oracle Corporation
>
> Pete Sharman
> Project Manager Fax: +1.650.633.
> Worldwide Internal Services Education
> Oracle Corporation
> 500 Oracle Parkway M/S OPL-B1024 Анс
> Redwood Shores
> California
> 94065
> USA
> SQL> select standard_disclaimer, witty_remark 2 from company_requirements; **** The statements and opinions expressed here are my **** **** own and do not necessarily represent those of **** **** Oracle Corporation. **** "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA
> Additional Information:
> Last Name Sharman
> First Name Peter
> Version 2.1
Received on Mon Jun 28 1999 - 20:02:40 CDT