Home -> Mailing Lists -> Oracle-L -> How to create index without lock it while is creating

How to create index without lock it while is creating

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Mon, 16 Oct 2017 11:36:58 -0300
Message-ID: <CAJdDhaOpPxoA_4KZtBV9yucL5O0McnX4t+Z=P6_Z3eKPn05JmA_at_mail.gmail.com> 





Hi,



I am using :


Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
Production              0


PL/SQL Release 12.1.0.2.0 -

Production                                                    0
CORE    12.1.0.2.0
Production                                                                0
TNS for IBM/AIX RISC System/6000: Version 12.1.0.2.0 -
Production                         0
NLSRTL Version 12.1.0.2.0 -
Production                                                    0


Executed in 1,249 seconds



I need to create a index in the production environmnent , but I cannot stop
the application and  also cannot lock the index while it is being created.



Is there a way to do it ?



Something like, create and rebuild it after creation.



​Regards


Eriovaldo


​


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


Received on Mon Oct 16 2017 - 16:36:58 CEST












Original text of this message