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

Thread: Sql Plus Oracle Question

  1. #1
    Join Date
    Feb 2001
    Location
    alexandria
    Posts
    100

    Question Sql Plus Oracle Question

    A friend of mine has this issue. Usually he is able to run a sql file from the command line using

    @/path/file.sql

    he did a reinstall of his oracle client and says when he tries to run the file now

    it opens up in notepad! rather than on the sql command line. Any one know why that is?

    Thanks.

  2. #2
    So this is a windows host? Is he running that command from within sqlplus or just the windows command prompt?

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Here is a theory...

    Usually your friend had open sqlplus and logged into the database before issuing his @/path/file.sql

    Now your fried is just typing @/path/file.sql at the MS-DOS prompt.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Ask him to check,

    Two possibilities:
    1) is he opening a .sql file from windows?? then what he did is right
    2) Is he running the .sql file from sqlplus/sqlplusw and it opens as a notepad before doing an edit, its weird
    "What is past is PROLOGUE"

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