How to run .sql file using sqlplus from powershell

Question

I am trying to run a .sql file form powershell as :-

sqlplus username/password@TnsAlias 'c:\path\to\DBscript.sql'

Here TnsAlias refers to my ORACLE_SID

Whenever i run this command, i get the standard usage instructions of sqlplus.

Could someone help me out on this.

I am running this on Windows Server 2012 and Powershell version 4.0,if it helps.

try test connection without sqlfile sqlplus username/password@TnsAlias — Dmitry Demin
– Dmitry Demin, Commented Aug 16, 2018 at 6:34

Littlefoot · Accepted Answer · 2018-08-16 06:00:10Z

1

This works for me:

PS M:\> sqlplus scott/tiger@kc11g "@m:\dbscript.sql"

SQL*Plus: Release 11.2.0.1.0 Production on ╚et Kol 16 07:59:25 2018

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options


    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

SQL>

answered Aug 16, 2018 at 6:00

Littlefoot

144k15 gold badges41 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tushar Yadav Over a year ago

I am using Oracle 12.1.0.2.0 Do you think that might be a reason for it not running

Littlefoot Over a year ago

I'm not sure whether you noticed the difference in the way you called the SQL script and the way I did it. Should be "@m:\dbscript.sql". I don't think that difference in database version has anything to do with it.

Collectives™ on Stack Overflow

How to run .sql file using sqlplus from powershell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related