Re: union of tnsnames.ora

From: Harry <harryooopotter_at_hotmail.co_>
Date: Mon, 01 Mar 2004 01:59:54 GMT
Message-ID: <uOw0c.37874$A12.30807@edtnps84>

bdjensen wrote...
>
>Hi!
>This would be easy, if the files are small.
>But the files are big - some hundred db's
>and I know that file A is better than file B (both files can describe the
>same instances, but sometime there may be differences!)
>
>Also important:
>The tns-name should only be listet a single time in the resulting file, in
>other
>case, it could be that the wrong would be edited in future.
>Greetings Bjørn

For each tnsnames.ora
Do
vi $file
Join the lines so that one SID per line Done
Cat all tnsnames.ora | sort | uniq > a_big_tnsnames.ora_sorted

Hope this help. Received on Sun Feb 29 2004 - 19:59:54 CST