Results 1 to 3 of 3

Thread: running script file in oracle

  1. Feb 19th, 2003, 03:05 PM #1
    mbonfyre
    mbonfyre is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2002
    Location
    Propped up at a PC near you...
    Posts
    194

    running script file in oracle

    Please could anybody tell me where I should save my script file to in order to run it in oracle. I have tried saving it in Oracle directory, but error:

    unable to open file accountUpdate.sql
    Reply With Quote Reply With Quote
  2. Feb 20th, 2003, 08:55 AM #2
    jayakumar
    jayakumar is offline
    Hyperactive Member
    Join Date
    Nov 2002
    Location
    india
    Posts
    418
    hi,

    open sqlplus

    at prompt type

    sql>@c:\test.sql
    Reply With Quote Reply With Quote
  3. Feb 20th, 2003, 09:18 AM #3
    mbonfyre
    mbonfyre is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2002
    Location
    Propped up at a PC near you...
    Posts
    194
    thanks for answering, but this does not work for me:

    SP2-0310: unable to open file "bank.sql"

    I have the file in c:

    Any idea what I am doing wrong?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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