Well, it looks like you are trying to do an "interactive" thing (&tbsp) in a non-interactive environment <<EOF.


Simply change &tbsp into $1 and pass the argument into the script. eg:




$ cat test.csh
#!/bin/csh

sqlplus -s /nolog <<EOF
connect /

Column tablespace_name format a25 heading "TABLESPACE"
Column initial_extent format 99,999,999 heading "INITIAL"
Column next_extent format 99,999,999 heading "NEXT"
Column min_extents format 99,999,999 heading "MIN"
Column max_extents heading "MAX"
Column CONTENTS format a9 heading "CONTENTS"
spool temp.txt
select
tablespace_name,
initial_extent,
next_extent,
min_extents,
decode(max_extents,2147483645,'UNLIMITED',max_extents) max_extents,
CONTENTS
from
dba_tablespaces
where tablespace_name=upper('$1');
spool off
clear columns
EOF


$ ./test.csh system
Connected.

TABLESPACE INITIAL NEXT MIN
------------------------- ----------- ----------- -----------
MAX CONTENTS
---------------------------------------- ---------
SYSTEM 16,384 16,384 1
505 PERMANENT