Pattern Matching

UNIX for Advanced & Expert Users
1

Hi Folks,

I have the following requirement:
I have a file that is containing numerous queries. The tables name mentioned in the queries are in the following format : SchemaName.Tablename. e.g COPDB.TableName.

I need to take out all the COPDB.TableName pattern and write it to a different file.
Note: Only the COPDB.TableName pattern.

Thanks in Advance.