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

Tks Stefan.

2017-10-16 12:54 GMT-02:00 Stefan Knecht <knecht.stefan_at_gmail.com>:

> 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