Insert into self, pause new indexing, then reindex. Oracle 9i
Posted on 2008-11-04
I would like to know if the following is possible. I can thing of ways around this, using multiple tables, but I would like to avoid it...
1. Create Table X
2. Bulk insert into table X from table Y
3. Index table X
4. Pause the indexing of newly inserted rows to table x
5. Insert into table X from table X
6. Reindex Table X (either all or newly added rows, don't care)
The point of #4 is to pause the indexing of the rows being inserted, but not drop the index as it will be useful when reading rows in #5.