In an archlog mode database, does oracle create redo log entries while creating an index ?
If so, what id the form of it ?
Is it just a DDL log ? or the actually index entries send to the redo?
yes , creating index creates the redo logs .
The redo log records all changes made to any database buffer, including data, index, and rollback segments, whether the changes are committed or uncommitted.
Redologs at the time of creating index
When you are creating index and and if you doesn't want redo'sto be generated, then create an index with nologging.
But if you encounter any instance or media failurem, you cannot recover it.
Thx for all taht reply my question.
So, what does it mean when I issue the following statement in sqlplus;
create index rev_order_idx1 on rev_order(order_no, prod_id) ;
if I have 5 millions rows in rev_order table, will Oracle generate a lot of redo logs or will there only 1 entry (creating index statement into the relo log) ?
Yes, it will generate enough redo to recreate the index. I would include the nologging parameter as previously suggested unless it would take an unreasonably long time to recreate the index if there were problems.
Senior Database Administrator
Click Here to Expand Forum to Full Width