3 Replies Latest reply: Feb 5, 2013 11:00 AM by Osama_Mustafa RSS

    Server Hang While trying to load Data using SQLLDR

    817202
      Hi guru's


      OS Version: Centos 6 64 bit
      DB Version : 11gR2 64 bit


      When i am trying to load data using SQL ldr the loading in between hangs. As well as when i am trying to transfer text files which are approx 14Gb using winscp then it show me error as mentioned below:

      Host is not communicating for more than 15 seconds.Still waiting..............
      Not:if problem repeats , by turning off 'Optimize connection buffer size'

      Warning : Abort this operation will close the connection


      I talked to our n/w admin regarding the same problem

      He blaim that its due to oracle not by any n/w


      can anyone help me in this respect.