ORA-01008

[itwizzkid]

I am getting ORA-01008 when running the following script. any help to get it to work will be appreciated.

Thanks in advance

SELECT f.file_name, ROUND (f.bytes / 1024 / 1024, 2),
f.blocks, f.autoextensible, ROUND (x.inc, 0), f.maxbytes, f.maxblocks,
f.status, x.maxextend, f.file_id
FROM sys.dba_data_files f, sys.filext$ x
WHERE f.tablespace_name = :tname
AND x.file#(+) = f.file_id

ORA-01008: not all variables bound

[UNIX DBA]

you are using bind variables like you would in forms.

This isn't right, are you trying to achieve user input parameters in you script?