Hi,

Suppose I have the following text in a file.

ORA-00942: table or view does not exist
ORA-01555: snapshot too old: rollback segment number string with name "string"
too small

Is there any way I can list all the text that starts only with 'ORA-'?
Or there any grep command that can pull out only 'ORA-xxxxx'? Having X as any number.

Please help.

thanks.

$ grep '^ORA-[0-9]\{5\}:' inputfile

Cheers
ZB

ZB,
I tried your suggestion but it still gives me the whole string, not the ORA-00942 text.

Try...

awk 'match($0,"ORA-....."){print substr($0,RSTART,RLENGTH)}' file1

Ygor,
I have to replace a valid number to RSTART and RLENGTH right?
I tried to run the command it gives me a syntax error/bailing out

thanks

No, RSTART and RLENGTH are awk built-ins which are set by the match function.
On Solaris, try nawk, otherwise post your error message.

hi try out this

grep "^ORA\-\[1\-9\]\{5\}" filename