Tks Stefan.
2017-10-16 12:54 GMT-02:00 Stefan Knecht <knecht.stefan@xxxxxxxxx>:
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@xxxxxxxxx> 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
| @zztat_oracle