Home » Other » Client Tools » How to execute a .sql file in sqlplus editor ?
How to execute a .sql file in sqlplus editor ? [message #255301] Tue, 31 July 2007 05:48 Go to next message
jeymukhi
Messages: 3
Registered: July 2007
Junior Member
Hi,

I have a set of SQL commands in a .sql file in my local machine. I have connected to the Oracle DB through sqlplus client. I want to execute the .sql file which is present in the local machine. How can I achieve that ?
Re: How to execute a .sql file in sqlplus editor ? [message #255302 is a reply to message #255301] Tue, 31 July 2007 05:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use "start" command.

Regards
Michel
Re: How to execute a .sql file in sqlplus editor ? [message #255307 is a reply to message #255302] Tue, 31 July 2007 05:57 Go to previous messageGo to next message
jeymukhi
Messages: 3
Registered: July 2007
Junior Member
Hi,

I have tried it , but it says 'unable to open the file'.
Note: The DB is in some other sever and the .sql file is on my desktop. So, Do I need to export the file to the server etc. If so, what are the commands for the same.
Re: How to execute a .sql file in sqlplus editor ? [message #255316 is a reply to message #255307] Tue, 31 July 2007 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Plus and script must be on the same machine which may not be the database server.
Verify your path and access rights.

Regards
Michel
Re: How to execute a .sql file in sqlplus editor ? [message #255330 is a reply to message #255307] Tue, 31 July 2007 07:44 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
jeymukhi wrote on Tue, 31 July 2007 06:57

I have tried it , but it says 'unable to open the file'.


Give the full path of the file.
Previous Topic: about sqlplus character
Next Topic: Unable to perform operations using 'dual' table: SP2-0575
Goto Forum:
  


Current Time: Thu Mar 28 08:52:53 CDT 2024