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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l