SQLPlus hangs in the middle of pulling data from database. SQL scripts are used in our system to pull data from one of databases. the sql script can be successfully run in Linux environment. However the same sql script can only pull partial data from the database table and hang in the middle of pulling when run in window environment.
linux: Red Hat Enterprise Linux Server release 6.3 (Santiago)