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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.