Home  Easy-Code   Forum    Updater 


Not signed in (Sign In)
    • CommentAuthorPaddy
    • CommentTimeSep 25th 2010
     
    1) Index creation syntax
    create index index_name on table_name(list of columns with comma seperated)
    tablespace tablespace_name
    logging
    parallel (degree 4);
    ex:Create index idx_empid on emp(empid,empname)
    tablespace tblspc_emp
    logging
    parallel (degree 4);
    2)How to alter an index from logging to nologging;
    Alter index idx_empid rebuild nologging;
    3)How to alter parallel parameter in index
    Alter index idx_empid rebuild parallel 12;

    REgards
    Paddy