Database error

[weikitty17]

Hello,

Can anyone try to help me debug this script? Or at least explains why the error occurs?

Error:
SP2-0734: unknown command beginning "where a..." - rest of line ignored.

SP2-0734: unknown command beginning "order by 5..." - rest of line ignored.

----------------------------------------------------------------------------------------

Script:

#!/bin/bash

output=‘sqlplus -s "/ as sysdba" <<EOF

set verify off

set echo off

set pagesize 9999

set feedback off

Spool on

set heading off

Spool <Insert filename>.csv

Select sysdate from dual



select nvl(b.tablespace_name,nvl(a.tablespace_name,'UNKNO WN')) ts_name

, kbytes_alloc kbytes

, kbytes_alloc-nvl(kbytes_free,0) used

, nvl(kbytes_free,0) free

, ((kbytes_alloc-nvl(kbytes_free,0))/kbytes_alloc)*100pct_used

, nvl(largest,0) largest

from (select sum(bytes)/1024Kbytes_free, max(bytes)/1024 largest, tablespace_name from dba_free_space group by tablespace_name) a, (select sum(bytes)/1024 Kbytes_alloc, tablespace_name from dba_data_files group by tablespace_name) b



where a.tablespace_name (+) = b.tablespace_name

order by 5,1

Spool off

exit

EOF

`
End of Script

THANK YOU!

[Motoma]

This is a problem with your Oracle commands. As such, I have moved this to the Oracle Forum with the hopes that the community there will be much more helpful.

[Saii]

Hello,

i think you need a ; after first select. Also there is some spacing problem for alias name used like pct_used, kbytes_alloc or maybe that is pasting typo..

hope that helps