Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Wierdness during script in SQLPlus

Wierdness during script in SQLPlus

From: Farnsworth, Dave <DFarnsworth_at_Ashleyfurniture.com>
Date: Wed, 01 May 2002 03:28:21 -0800
Message-ID: <F001.00454B34.20020501032821@fatcity.com>


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: DFarnsworth_at_Ashleyfurniture.com

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: ListGuru_at_fatcity.com (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). Received on Wed May 01 2002 - 06:28:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US