var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have to load a 10000000-line file to a table which is with triggers, and the DB is with unbuffered loging.
What shall I do to load the fat file as quick as possible?
Is it possible to turn off trigger and loging mode in SQL language? How?
I need the SQL command and execute it for a everyday job.
There are some way, for example:
Disabled trigger, set triggers for table disabled.
Use utility dbload.
Alter table to type raw, next insert, alter table to type standard and do back-up.
Use utility onpload.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors