-
Hi Everyone.
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?
Thx
matthewc
-
yes , creating index creates the redo logs .
-
Hi,
Yes,
The redo log records all changes made to any database buffer, including data, index, and rollback segments, whether the changes are committed or uncommitted.
Thnx
P. Soni
-
Redologs at the time of creating index
Hi,
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.
Regs
Sundarganesh
v.sundarganesh
-
Hi.
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) ?
Thx
matthewc
-
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.
Joe
_________________________
Joe Ramsey
Senior Database Administrator
dbaDirect, Inc.
(877)687-3227
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|