Discussion Locked

library process dead

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have been trying to clean up a corrupted table, trans_hist table and others on our database. After creating a tmp_trans_hist table and then enter this script:

insert into tmp_trans_hist
select * from trans_hist

I get this message:

DB- Library process dead - connection broken

Can someone tell me what is happening.

4 replies

by jmiller1

Try doing a SELECT * INTO instead of INSERT INTO..SELECT.

SELECT * INTO tmp_trans_hist
FROM trans_hist

The corruption in the table could be killing the process. Make sure you have the 'SELECT INTO/BULK COPY' option set for this database before running the above statement.

jm

This discussion is closed to new replies.