Sorry.. someshellcommand lalalala someshellcommand construct sql > external.sql add sql >> external.sql evenmore sql >> external.sql echo exit >> external.sql sqlplus username/incrediblysecretpassword -s @external HTH, Bambi. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Joan Hsieh Sent: Tuesday, October 06, 2009 10:20 AM To: oracle_l Subject: sqlplus Hi List, I have a shell script report the following output for my daily check routine. I found the SQL> SQL> SQL> is very annoying, is it possible to get rid off the "lines from coonected to:" to 2 3 4...13" ? Thanks, Joan Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 Thread LastSeqApp1stti Last Sequence Applied LastSeqRec1stti Last Sequence Received DiffSeq DiffMins ---------- --------------- --------------------- --------------- ---------------------- ---------- ---------- 1 06-OCT-09 1428 06-OCT-09 1428 0 0 SQL> SQL> SQL> 2 CURRENT_LOG_GAP --------------- 0 SQL> SQL> 2 3 4 PROCESS SEQUENCE# STATUS --------------------------- ---------- ------------------------------------ ARCH 1426 CLOSING ARCH 1427 CLOSING ARCH 1428 CLOSING RFS 1429 IDLE MRP0 1429 APPLYING_LOG SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l