When it is not practical to lock up your base table for indexing because of ongoing updates, you can create your index online with the ONLINE
parameter of CREATE INDEX
. This way an application with heavy DML need not stop updating the base table for indexing.
There are short periods, however, when the base table is locked at the beginning and end of the indexing process.
Oracle Text Reference to learn more about creating an index online