DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01008

  1. #1
    Join Date
    Feb 2001
    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

  2. #2
    Join Date
    Sep 2001
    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

Click Here to Expand Forum to Full Width