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

Home -> Community -> Usenet -> c.d.o.server -> SQLPLUS input truncated error

SQLPLUS input truncated error

From: dennis liu <dliu_at_neostrata.com>
Date: Mon, 25 Oct 1999 13:40:17 -0400
Message-ID: <38149601.6E67@neostrata.com>


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 - 12:40:17 CDT

Original text of this message

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