|
Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006
Bcp in large scale obstruction I BCP used in transplant database, a table is always guided the 1G not get, in general guide to the record of 777,000 T, where Sybase System on the cards for this big there any way ah, that loom 3G allocation of CPU, memory 1G |
Table proposed split, then BCP bars, the best bars TEMPEST reservoir expansion. |
Errorlog see if they had any information, or to see if there are any processes or lock |
To see whether the log is full. Bcp -b1000 introduce the use of a form of 1000 |
Fast BCP proposal
BCP is when you bring in the right LOG
Fast BCP proposal
It is required as follows :
1, db_option 'select into' true
2, bound to remove all forms : (trigger, the index, primary key, constraint, foreign key) |
Oh, Thank you, the problem is LOG, BCP at the log has grown extremely rapidly, mainly novice with careless ah, look at the log, in the hope that we can start the trunc log on chkpt, neither do checkpoint |
Deleted index put first, and then bcp |
| |