Hi Dave, I believe in older versions of sql*plus there was a DOCUMENTATION (DOC>) function that would spit comments back to the user with the DOC> prompt. I know I've seen this before, a long time ago. It never affected anything I was running tho.
Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-309-4157 > -----Original Message----- > From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, May 01, 2002 7:28 AM > To: Multiple recipients of list ORACLE-L > Subject: Wierdness during script in SQLPlus > > I have a script that I run to update statistics on my databases that is > giving me something odd when run on a 7.3.4 database on NT 4.0. The > script runs fine on my 8.1.7 and 8.0.5 databases. It happens when the > script comes to an end. Below is what my screen looks like in SQLPlus; > > SQL> analyze table MP2.MOSIA_OUT_POLINE compute statistics; > > Table analyzed. > > SQL> analyze table MP2.REQORDOP compute statistics; > > Table analyzed. > > SQL> DOC>*/ > DOC>spool off > DOC>exit > DOC> > DOC> > > > What is happening when the prompt goes from "SQL>" to "DOC>"?? This does > not happen on the 8.x databases. The script finishes without errors but I > don't know what this is. Any ideas?? > > Thanks, > > Dave > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
