removing pattern which is spread in multiple lines

sabyasm · #1 (**permalink**) 05-12-2008

I have several huge files wich contains oracle table creation scripts as follows:

Quote:

CREATE TABLE PROD_MST.PROD_DEF_ALLOWED_RESELLERS (
PROD_DEF_ALLOWED_RESELR_ID NUMBER NOT NULL,
SRVC_PROVIDER_ID NUMBER NOT NULL,
CREATED_BY VARCHAR2(40 BYTE) NOT NULL,
CREATED_DTIME DATE NOT NULL,
LAST_UPDATED_BY VARCHAR2(40 BYTE) NOT NULL,
LAST_UPDATED_DTIME DATE NOT NULL,
PROD_ID NUMBER NOT NULL
)
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
TABLESPACE CUST_MASTER_DATA
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
LOGGING
;

CREATE TABLE PROD_MST.PROD_DEFINITION (
PROD_ID NUMBER NOT NULL,
PROD_NAME VARCHAR2(100 BYTE) NULL,
PROD_STATUS VARCHAR2(20 BYTE) NULL,
PROD_CODE VARCHAR2(40 BYTE) NULL,
PROD_CODE_TYPE VARCHAR2(40 BYTE) NULL,
PROD_EFFECTIVE_START_DATE DATE NULL,
PROD_EFFECTIVE_END_DATE DATE NULL,
SRVC_PROVIDER_ID NUMBER NOT NULL,
CREATED_BY VARCHAR2(40 BYTE) NOT NULL,
CREATED_DTIME DATE NOT NULL,
LAST_UPDATED_BY VARCHAR2(40 BYTE) NOT NULL,
LAST_UPDATED_DTIME DATE NOT NULL
)
PCTFREE 10
PCTUSED 0
INITRANS 1
MAXTRANS 255
TABLESPACE PROD_MASTER_DATA
STORAGE (
INITIAL 65536
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
LOGGING
;
.....
and so on

I would need to remove the pattern colored in red above. Any sed/awk/pearl code will be of much help.

Thanks

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
removing a line containing a pattern in sed	Fire_Storm	Shell Programming and Scripting	1	04-20-2008 05:13 AM
Concatenating multiple lines to one line if match pattern	phixsius	Shell Programming and Scripting	13	01-24-2008 11:02 PM
spawning multiple processes spread across two files	StrengthThaDon	High Level Programming	1	09-17-2007 05:03 PM
Can I spread commands over multiple lines?	tphyahoo	UNIX for Dummies Questions & Answers	1	06-07-2006 09:08 AM
Search file for pattern and grab some lines before pattern	frustrated1	Shell Programming and Scripting	2	12-22-2005 03:41 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by