DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Urgent Unix help with file editing

  1. 05-14-2002, 10:48 AM #1
    roukie_dba
    roukie_dba is offline Member
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    Dear Unix Gurus

    I have a large ascii file which contains several create statements as follows:

    CREATE UNIQUE INDEX "WWFSPROD"."PS_JRNLGEN_SEL_30" ON "PS_JRNLGEN_SEL_30" "PROCESS_INSTANCE" , "CHARTFIELD" , "RANGE_FROM_30" , "RANGE_TO_30" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE (INITIAL 122880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 495 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "FSAPP_INDEX" LOGGING ;

    I would like to edit the file and delete all the words between 'STORAGE' and 'DEFAULT' inclusive. Would someone please give me how I can either use vi editor, SED or any other simple unix tool to achieve that?

    Thanks a lot,
    roukie-dba
    Reply With Quote Reply With Quote
  2. 05-14-2002, 11:01 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    duplicate thread, closing.
    Jeff Hunter
    Reply With Quote Reply With Quote
    3. « Previous Thread | Next Thread »

    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