Re: How to create index without lock it while is creating

Have a look at the ONLINE option of the CREATE INDEX statement.

It does need a (usually brief) lock, but only at the very end, with its length depending on how much activity is on the underlying table.

https://docs.oracle.com/database/121/SQLRF/statements_5013.htm

On Mon, Oct 16, 2017 at 9:36 PM, Eriovaldo Andrietta <ecandrietta_at_gmail.com> wrote:

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

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat |
_at_zztat_oracle

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