try this: sqlplus > set feedback off veri off Michael Fontana NTT/Verio Senior Database Administrator mfontana@xxxxxxxxx 214.853.7405(Office) 214.912.3705(Wireless) ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Remigiusz Sokolowski Sent: Wed 11/8/2006 6:54 AM To: oracle-l@xxxxxxxxxxxxx Subject: sqlplus and error stream Hi! I wonder if is there in sqlplus a possibility to turn error output off? Or stream it to some place other than stdout or file used for spooling? And I mean all errors, not only sqlplus errors The reason behind it is to produce clean scripts of course ... Regards Remigiusz -- --------------------------------------- Remigiusz Sokolowski <rems@xxxxxxxx> WP/PTI/DIP/ZAB (+04858) 52 15 770 MySQL v. 4.x Oracle v. 10.x --------------------------------------- -- //www.freelists.org/webpage/oracle-l