How in the Oracle inside the bulk insert data, is how to write the script

Now there are 1000000 data, these data in a.Sql file, or the file now only insert into statement, others did not, I should add what in this file, can let it take the data into the database, that is to say how to run up, the CMD command is how to write to master, the script writing and the CMD command to tell me

Started by Kristine at November 22, 2016 - 4:37 PM

What file inside the data looks, post some sample data to see

Posted by Archer at November 26, 2016 - 5:06 PM

CMD
SQLPLUS
The username / password
@The path to the file. The file name

You can in front of file to execute with the @ symbol.

Posted by Murphy at December 04, 2016 - 5:37 PM

sqlplus jh*/jh*@test003 @d:\a.sql

Posted by Henry at December 07, 2016 - 6:29 PM

su - oracle
sqlplus / as sysdba
conn username/password
@a.sql

Posted by Harlan at December 20, 2016 - 6:51 PM