Is it safe to "create index.. ONLINE in 8.1.7.3"

  • From: Jay <jaysingh1@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 29 Feb 2004 16:18:40 -0500

Dear Gurus,

I need your opinion about creating index ONLINE in version 8.1.7.3 in
production environment.
We would like to create an index on one of our primary table, since the
system is live (and no outage scheduled)  like to build a new index ONLINE.

Few months ago somebosy reported saying that BLOCK CORRUPTION oCCURED
because of CREATE INDEX ... ONLINE.

Does anyone experience this kind situation? Any feedback on this would be
really appreciated.

Thanks
Sami

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: