Need to print certain lines from a file

[jack00423]

Hi ALL,

I want to print some lines from file like
example
=====
RECOVER DATABASE
ALTER DATABASE OPEN;
ALTER TABLESPACE TEMP ADD
ALTER TABLESPACE TEMP ADD STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 16
MAXLOGMEMBERS 5
MAXDATAFILES 512
MAXINSTANCES 1
MAXLOGHISTORY 7260
LOGFILE

I want to print the lines from "ALTER TABLESPACE TEMP ADD " to till "MAXINSTANCES 1"

Pleas help me in this
Thanks
Jack

[Salem]

awk '/ALTER TABLESPACE TEMP ADD/,/MAXINSTANCES 1/' file.txt

Or something like it.

[jack00423]

It worked for me..Thanks a lot reply...

[pritishs]

cat -n filename|tail +3 |head -8

cat  -n filename|head -10|tail -8

cat -n filename|sed '3,10p'

cat -n filename|grep -B +7 "10"