Geek Answers Handbook

Oracle Database.sql command line

I want to import the .sql file into Oracle on the command line so please tell me that the command to import the .sql file into oracle in MYSQL I use 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

+10
sql oracle oracle10g oracle11g oracle-sqldeveloper
source share
4 answers

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

 c:\> sqlplus user_name/user_password@connect_string @path\your_sql.sql
+15
source share

Try using sqlplus :

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

Additional Information.

+6
source share

It is worth knowing that you may have a space between @ and the input file, which allows you to use the automatic completion of the tab key.

+2
source share

You can also export the SQLPATH environment variable (colon-separated list of directories) for common scripts that you do not want to output from the table / complete the full path each time.

0
source share

More articles:


All Articles