-
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
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|