Circumstances Under Which You Cannot Create or Drop Indexes Online

You cannot use the CREATE INDEX ONLINE statement:

• To create an index at the same time that a table is being altered
• To create a clustered index
• To create a Virtual-Index Interface (VII) /R-tree index
• To create a functional index
• To create an index online statement that is inside a transaction

You cannot use the DROP INDEX ONLINE statement:

• To drop a Virtual-Index Interface (VII) /R-tree index
• To drop a clustered index
• To drop an index online statement that is inside a transaction