RE: rebuild index

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 24 Jan 2001 14:08:46 -0000
Message-Id: <10751.127356@fatcity.com>

I'm pretty sure that Oracle will do this on 8.1.5, but I am currently running under 8.1.6 R2 at the moment so can't test it. Can anybody else confirm this? If not you can always allocate the extents manually:

ALTER INDEX xpc_entries_pk? ALLOCATE EXTENT (

      SIZE K|M,
	DATAFILE 'DISK1/BLAH/BLAH/BLAH');

Then all you would have to do is allocate each extent to each datafile manually..

HTH Mark

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

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Joan Hsieh Sent: Wednesday, January 24, 2001 01:05
To: Multiple recipients of list ORACLE-L Subject: RE: rebuild index

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

Sent: Wednesday, January 24, 2001 5:55 AM To: Multiple recipients of list ORACLE-L

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

--

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