Does creating indexes create redo log ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Does creating indexes create redo log ?

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    24
    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

  2. #2
    Join Date
    Jul 2000
    Posts
    119
    yes , creating index creates the redo logs .

  3. #3
    Join Date
    Feb 2001
    Posts
    125
    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

  4. #4
    Join Date
    Aug 2000
    Posts
    10

    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

  5. #5
    Join Date
    Mar 2001
    Posts
    24
    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

  6. #6
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    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
  •  



Click Here to Expand Forum to Full Width