RE: rebuild index

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 24 Jan 2001 10:50:53 -0000
Message-Id: <10751.127345@fatcity.com>

AFAIK if you are using 8i, if you use two datafiles (one on each disk) Oracle will automatically do this for you (Provided that there is space in each datafile). I have found through my own testing that if you initially create 2 or more datafiles, that Oracle will do this "striping" for you..

Not quite sure how raw disks work though to be honest (Wouldn't mind a URL if anyone has one for a tech paper or something.. learn learn learn), seeing as most of my experience is on NT with NTFS - I know I know..

What Oracle version are you using?

Mark

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Joan Hsieh Sent: Tuesday, January 23, 2001 09:41
To: Multiple recipients of list ORACLE-L Subject: rebuild index

Hi Listers,

I am wondering is it possible to manually striping the extents while rebuild the index on line?

I want to rebuild one index has 9 extents in 2 separate raw disk files. tablespace is xpc_entries_pk. How can I rebuild this index for instance: extents 1 goes to /disk1, extents 2 goes to /disk2, extents 3 goes to /disk1...
Does rebuild index allows to do this?

Thanks in advance,

Joan

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Joan Hsieh
  INET: Joan.Hsieh_at_mirror-image.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 24 2001 - 04:50:53 CST