From: harryooopotter@hotmail.co_   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)