RE: "create index offline"

Yes, though I think that it could be a bit more clearly stated.

I think the note is saying "If you run into this bug while doing an
online index rebuild, then don't do the rebuild online."

-Mark 


--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be
done at all.  -Peter F. Drucker, 1909-2005


-----Original Message-----
From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
[mailto:genegurevich@xxxxxxxxxxxxxxxxxxxxx] 
Sent: Thursday, November 09, 2006 6:39 PM
To: Bobak, Mark
Cc: Bobak, Mark; oracle-l@xxxxxxxxxxxxx
Subject: RE: "create index offline"

Mark,

So what you think is that the note means is "alter index rebuild"
instead of "alter index rebuild online"?

thank you

Gene Gurevich



 

             oracle-l-bounce@f

             reelists.org

 
To 
             11/09/2006 05:13          "Bobak, Mark"

             PM                        <Mark.Bobak@xxxxxxxxxxxxxxx>,

 
<genegurevich@xxxxxxxxxxxxxxxxxxxxx 
                                       >, <oracle-l@xxxxxxxxxxxxx>

             Please respond to
cc 
             Mark.Bobak@xxxxxx

                 quest.com
Subject 
                                       RE: "create index offline"

 

 

 

 

 

 





Ok, I was curious, so, I did a MetaLink search.  I found a bug related
to rebuilding an index online.  The workaround listed was "create index
offline".  In this context, I think all it means is to do the index
rebuild or index create without specifying the 'online' keyword.

-Mark


--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be
done at all.  -Peter F. Drucker, 1909-2005


-----Original Message-----
From: Bobak, Mark
Sent: Thursday, November 09, 2006 6:11 PM
To: 'genegurevich@xxxxxxxxxxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: RE: "create index offline"

I'm not aware of any such syntax.  You can create index "online".  This
indicates that DML can be happening on the table during index creation.

I'm only familiar with "offline" in the context of tablepaces and
datafiles.

-Mark


--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be
done at all.  -Peter F. Drucker, 1909-2005


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
genegurevich@xxxxxxxxxxxxxxxxxxxxx
Sent: Thursday, November 09, 2006 6:04 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: "create index offline"

Hi all:

I have been reading documents on Metalink and ran into phrase "create
index offline". I don't remember seeing that before and I was wondering
whether it refers to dropping and recreating index (as opposite to alter
index rebuild) or whether it means something totally different.

thank you

Gene Gurevich


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l






--
http://www.freelists.org/webpage/oracle-l

Other related posts: