[Oracle] Create Index Online Vs Create Index
-
Hi all, I have a little confusion about creating index on Oracle, which is the difference between creating index online and creating them in not an online way (offline). I looked it on internet and I did not find sth straight about it but I guess that : Online : The RDBMS will create the Index without using table locks (for DML statements when creating the index). Offline : create with the use of tables lock. Am I correct ? Thank you.
"The Ultimate Limit Is Only Your Imagination."
-
Hi all, I have a little confusion about creating index on Oracle, which is the difference between creating index online and creating them in not an online way (offline). I looked it on internet and I did not find sth straight about it but I guess that : Online : The RDBMS will create the Index without using table locks (for DML statements when creating the index). Offline : create with the use of tables lock. Am I correct ? Thank you.
"The Ultimate Limit Is Only Your Imagination."
Yes.
Politicians are always realistically manoeuvering for the next election. They are obsolete as fundamental problem-solvers. Buckminster Fuller