sqlplus

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 06 2009 - 10:20:05 CDT