Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPLUS input truncated error
Cut and paste your code, works great!
dennis liu wrote in message <38149601.6E67_at_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 - 17:37:36 CDT