Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQLPLUS input truncated error
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