11

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

Improve this question

4 Answers 4

Reset to default
19

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

c:\> sqlplus user_name/user_password@connect_string @path\your_sql.sql
Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

you need to give full path ? like C:\oraclexe\app\oracle\product\11.2.0\server\demo\schema
what is @connect_string here?
8

Try to use sqlplus:

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

More information.

Improve this answer

1 Comment

How to import .dmp file with its .log to the already created database as the structure aresame
2

It's worth knowing you can have a space between @ and the input file, which enables the use of the tab key auto completion.

Improve this answer

Comments

0

You can also export the SQLPATH environment variable (colon separated list of directories) for common scripts you don't want to bang out/tab complete the full path every time.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.