RE: rebuild index

From: Joan Hsieh <Joan.Hsieh_at_mirror-image.com>
Date: Wed, 24 Jan 2001 08:07:35 -0500
Message-Id: <10751.127350@fatcity.com>

Mark,

Thanks for the information, we use 8.1.5. So as you said, oracle does it automatically? The index is 2 gb large. That's why we want spread it out on two disks evenly. This is internet service company. speed is everything.

Thanks,

Joan

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

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Mark Leith Sent: Wednesday, January 24, 2001 5:55 AM To: Multiple recipients of list ORACLE-L Subject: RE: rebuild index

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-----

Sent: Tuesday, January 23, 2001 09:41
To: Multiple recipients of list ORACLE-L

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).

--

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

Author: Mark Leith
INET: mark_at_cool-tools.co.uk

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