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

Thread: SP2-0310 Unable to open file

Hybrid View

  1. #1
    Join Date
    Jul 2001
    Posts
    45

    Angry

    Hi all,
    I find a script that I have copied and saved on the notepad as all files with extension .sql. (REPORT.sql)
    when running the script on the sqlplus, i was getting the following error.

    SQL> @report.sql
    SP2-0310: Unable to open file "report.sql"
    Can someone tell me what that error is about? and how to go by correcting it?
    Thanks
    Richard

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    You might check for a 'report.sql.txt'. I have had that happen a couple of times.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi Richard,

    Make sure you have save ur file in ORACLE_HOME/bin directory becuase by default it looks into this directory for the file you might have saved it in a differnt directory

    Regards,
    Santosh

  4. #4
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Search for the location of the file. It may be in the Oracle Bin directory.

    Then

    c:> sta (full path)\report.sql

    or else copy the file to the c:>

    then

    C:> sta report.sql (or @report.sql)

    If you do not specify a path while saving it gets saved to the Oracle bin directory by default.
    Hemant

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