Tag Info

New answers tagged


As @BalazsPapp mentioned, the oracle db can be connected locally even without a listener. In this case, the BEQ (Bequeath) protocol is used, instead of the tcp-based normal oracle communication. Although on Balazs's link there is nothing about the details of the BEQ. On unix, it probably uses unix domain sockets. On windows, it uses probably some local rpc. ...


That's because of the set linesize 1000 clause. That one is making all your lines in the spool file to be 1000 rows long, even if there is no such data. Try this from a clean SQL sqlplus session: set linesize 1000 spool test.txt select * from dual; spool off exit Then, go back to shell and open the test.txt with any text editor, move to the lines ...

Top 50 recent answers are included