try to extrac 'CREATE TABLE' by using vim?
s9225Nov 3 2008 — edited Nov 4 2008Hi friends:
I have a large file, so how can I extract only those 'CREATE TABLE....' clause till ';' from this file (--like below) and save it to a new file, say '2.sql'
CREATE TABLE "HCDCNV"."ADDR_AGREEMENT" ("AGREEMENT_ID" NUMBER,
"AGREEMENT_CODE" VARCHAR2(64) NOT NULL ENABLE, "AGREEMENT_EFF" DATE
NOT NULL ENABLE, "CRTN_DT_TMSTMP" DATE NOT NULL ENABLE, "IS_VALID"
VARCHAR2(1) NOT NULL ENABLE, "CRTN_LGN_ID" VARCHAR2(20) NOT NULL
ENABLE, "MDFD_DT_TMSTMP" DATE NOT NULL ENABLE, "MDFD_LGN_ID"
VARCHAR2(20) NOT NULL ENABLE) PCTFREE 10 PCTUSED 80 INITRANS 1
MAXTRANS 255 STORAGE(INITIAL 1048576 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE "CONVTABLES" LOGGING NOCOMPRESS ;
I tried
:g/^CREATE TABLE/,/;/ w!>> 2.sql
but won't work, anything that I need to change?
thanks a lot in advance
Jerry