Search Results

Try with single quote
echo '
set lines 2000
set pagesize 100
select a.tablespace_name as "tablespace",allocated as "size in gb",
(a.allocated - nvl(b.freespace,0)) as "used space in...

How about this ?
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=orcl
echo "
spool /home/oracle/tablespace_analysis.log...

You don't use :, but ; at the end of the find statement.

Alse please use code tags for posting code.

Hope that helps

Regards
Peasant.