Oracle Database import .sql file by command prompt

Question

I want to import .sql file in Oracle by command prompt so please tell me that command to import .sql file in oracle in MYSQL I am using it like this

mysql -u root -p -h localhost softpoint < D:\Nisarg\NEult\softpoint.sql

but In Oracle I don't know how to use this utility so please help me

Thanks

Nicholas Krasnov · Answer 1 · 2013-07-18 12:23:47Z

up vote 0 down vote

In Oracle, to run a script (*.sql) you use SQL*PLUS command line utility.

c:\> sqlplus user_name/user_password@connect_string @path\your_sql.sql

answered 32 mins ago

Nicholas Krasnov
6,4651725

Parado · Answer 2 · 2013-07-18 12:33:04Z

up vote 0 down vote

Try to use sqlplus:

  sqlplus user/password@connect @/Nisarg/NEult/softpoint.sql

edited 23 mins ago

answered 32 mins ago

Parado
5,9232620

2 Answers