Note After creating or dropping an index, you must commit (or roll back) your work before you can modify the data in the table on which you created or dropped the index.