My article one million insert statement in SQL file, how to quickly import database?

CodePudding user response:

@ c:/1. SQL

CodePudding user response:

Who put the 100 w data export insert statement, so people's god

CodePudding user response:

1, the document processing, each 1 w or 5 w, add a commit; Awk can implement the
2, a file is split into multiple small files, then use 1 # method respectively to carry out, after perform a file, and then perform a commit;

CodePudding user response:

I think you can put the SQL file in a text editor tool bulk changes under
Finally left column value + comma, save the TXT or CVS and then use SQLLDR import
'1', 'name'
'2' name2 '

CodePudding user response:

reference 4 floor dd215130268 response:

I can feel the SQL file in a text editor tool bulk changes under
Finally left column value + comma, save the TXT or CVS and then use SQLLDR import
'1', 'name'
'2', 'name2

Good, this method can give it a try

CodePudding user response:

Tables in parallel, nologging, @ 1. SQL execution, do not have what problem

CodePudding user response:

In command mode execution
Under WINDOWS
@ \ full path to the file filename. Such as SQL under the C disk 1. TXT @ C: \ 1. TXT
Linux under the same is true of writing different only

@/TMP/1. TXT

Is actually the extension TXT or SQL are no relationship, it is best to use SQL because under Linux because TXT character set issues may appear garbled unable to import

CodePudding user response:

For the one million insert statement I serve only one word!!!!!!!!!!

CodePudding user response:

Use SQLLDR import userid=Scott/oraclecontrol=D: \ t_order_ctl TXT direct=y bindsize=8192000 rows=10000

CodePudding user response:

Put outside the table's primary key, index what the deleted, and then try to perform;

CodePudding user response:

SQLCMD -u sa -p password - S IP - d - r - I file address database name

CodePudding user response:

SQLCMD -u sa -p password - S IP - d database name - r - I file address & lt; - this is a sure answer,


If only one file, you can also directly pure mouse dots to complete the work,

CodePudding user response:

Log on to the database server, enter up SQLPLUS and then use the @ filename. SQL operations