Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPLUS input truncated error
Apparently you did not put a <CR> (press "Enter") after "spool off"
in your script. "spool off" has 9 characters. If you finished typing
"spool off" and then save, the end-of-file is immediately after it.
SQL*Plus does not seem to like this (although the script will run
without a problem other than the "Input truncated to 9 characters"
message). To avoid this message, just press enter after "spool off"
(so that the cursor is located in the begining of a new line), and then
save the script.
Xuequn Xu, Oracle DBA
Caltech, Pasadena, CA
dennis liu (dliu_at_neostrata.com) wrote:
: I try to generate a script from sqlplus, the result file is fine except
: there is an "Input truncated to 9 characters" message at the end of
: script file generated. what is it means and how to fix it?
: I list the sql file bellow.
: thank you for your help
: --this script file runs under user 'sys'
: set feedback off heading off verify off echo off termout off
: set long 255
: spool sysgrant.xxx
: select 'grant select on '||OBJECT_NAME||' to '||'system;'
: from dba_objects
: where owner='SYS' and object_type = 'VIEW' and object_name like 'V%';
: spool off
Received on Mon Oct 25 1999 - 17:48:09 CDT