OraFAQ Forum: Client Tools » How to execute a .sql file in sqlplus editor ?

Home » Other » Client Tools » How to execute a .sql file in sqlplus editor ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to execute a .sql file in sqlplus editor ? [message #255301]

Tue, 31 July 2007 05:48

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 ?

Report message to a moderator

Re: How to execute a .sql file in sqlplus editor ? [message #255302 is a reply to message #255301]

Tue, 31 July 2007 05:49

Michel Cadot
Messages: 68768
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use "start" command.

Regards
Michel

Report message to a moderator

Re: How to execute a .sql file in sqlplus editor ? [message #255307 is a reply to message #255302]

Tue, 31 July 2007 05:57

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.

Report message to a moderator

Re: How to execute a .sql file in sqlplus editor ? [message #255316 is a reply to message #255307]

Tue, 31 July 2007 06:45

Michel Cadot
Messages: 68768
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to execute a .sql file in sqlplus editor ? [message #255330 is a reply to message #255307]

Tue, 31 July 2007 07:44

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.

Report message to a moderator

Previous Topic:	about sqlplus character
Next Topic:	Unable to perform operations using 'dual' table: SP2-0575

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 02 05:28:34 CDT 2025