Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: rebuild index

RE: rebuild index

From: Joan Hsieh <Joan.Hsieh_at_mirror-image.com>
Date: Thu, 25 Jan 2001 09:06:14 -0500
Message-Id: <10752.127472@fatcity.com> 





That's true. I found this on metalink.



[BUG:1475310] ALTER INDEX .. REBUILD ONLINE can Corrupt The Index



Joan



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



From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Sonja
Sehovic


Sent: Thursday, January 25, 2001 5:51 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: rebuild index




You shouldn't use rebuild online. It corumpts your blocks. Instead you can
use


ALTER INDEX.....REBUILD PARALLEL


HTH


        Sonja




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



Sent: Wednesday, January 24, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L




Hi Listers,



First, I just test it works or not. So my rebuild index script like this;
ALTER INDEX XPC.ENTRIES_PK REBUILD ONLINE

TABLESPACE XPC_ENT_URL_TEMP STORAGE ( INITIAL 50m
NEXT 50m PCTINCREASE 0 MAXEXTENTS 2147483645);
Tablespace xpc_ent_rul_temp has 2 separate 1gb files.




But I got this errors,



SQL> @index_rebuild_run


ALTER INDEX XPC.ENTRIES_PK REBUILD ONLINE

*


ERROR at line 1:


ORA-03113: end-of-file on communication channel



I connect again and rerun it, now this time I got



SQL> @index_rebuild_run.sql


ALTER INDEX XPC.ENTRIES_PK REBUILD ONLINE

*


ERROR at line 1:


ORA-08106: can not create journal table XPC.SYS_JOURNAL_2755




SQL> !oerr ora 8106


08106, 00000, "can not create journal table %s.%s"
// *Cause:  online index builder can not create its journal table
// *Action: rename your table in conflict



SQL> drop table XPC.SYS_JOURNAL_2755;



Table dropped.



SQL> @index_rebuild_run.sql


ALTER INDEX XPC.ENTRIES_PK REBUILD ONLINE

*


ERROR at line 1:


ORA-00600: internal error code, arguments: [kkdlfjou_1], [], [], [], [], [],
[], []




SQL> @index_rebuild_run


ALTER INDEX XPC.ENTRIES_PK REBUILD ONLINE

*


ERROR at line 1:


ORA-00600: internal error code, arguments: [kkdlfjou_1], [], [], [], [], [],
[], []



Now I am in real trouble. I checked metalink, cannot find kkdlfjou_1
entries, maybe I shouldn't drop the xpc.sys_journal table. Any ideas ??



Thanks in advance,



Joan


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



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




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



Sent: Wednesday, January 24, 2001 01:05


To: Multiple recipients of list ORACLE-L




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


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


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: 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: =?iso-8859-1?Q?Sonja_Sehovic?=


  INET: sonja.sehovic_at_zg.tel.hr


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
Received on Thu Jan 25 2001 - 08:06:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US