Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    67

    Unanswered: execute .sql file in SQL Plus

    Hi.

    I have a dump file (dump.sql) and I need to execute it in Oracle 9i.
    The file is big, so TOAD takes a lot of time to execute it.
    Is there any way to execute a file via SQL Plus ?
    I.E. "Execute myfile.sql" or something similar.

    Thanks in advance.
    Diego.-

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    For the purpose of this example, I will assume that your dump.sql is in the c:\temp directory. Connect to the database in sql*plus and type

    start c:\temp\dump.sql
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •