First i connect to oracle remotely, then open pl/sqldeveloper create one table. Then i am trying to import csv file to PL/sql developer. Importing process starts normally, but every day midnight we face

ORA-03135 connection lost contact.

The file is almost 3 GB containing 20 million records.

the importing process stop after 10 million records.

1 Answer 1


I think check your network connection. In between your network connection interrupted. So In your sqlnet.ora and also on sqlnet.ora on your server try to change inbound connection or outbound connection and also try to set connection timeout parameter in sqlnet.ora file.

  • What is a crore?
    – miracle173
    Jan 24, 2018 at 17:05
  • 1
    "every day midnight". Hmm. Do you have a cold backup job scheduled that shuts the db down? In any event, I'd be looking at the db alert log for clues .. what is logged at the time the process fails.
    – EdStevens
    Jan 24, 2018 at 22:27
  • 1 crore is 10M. It is used in India a lot. May 8, 2018 at 20:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.