Insert problems for non-sybase Admin

[lebeama]

I have been charged with attempting to recover a mismanaged DB. A table has gotten whacked that needs to be rebuilt. This table has good data in it but is missing other data.

I have collected the necessary data in another table and want to insert this data into the main table. There are 34K unique rows. I am using the command:

INSERT INTO nri.student_course (ssn, course_code, course_edition, enrolled_date)
SELECT ssn, course_code, course_edition, enrolled_date
from loadtable4;
commit

This should work as all the fields are configured properly. This thing runs for days with no results, no errors. I do not know what is going on as this is Sybase 6!!! Please do not blame me as this is an gov't problem and I have been thrown at it in a last ditch effort to resolve this. Any advice would be appreciated.

 

[computergeek]

Hi,

Do you have an index on loadtable4? If not, try placing one on this table. Next remove any indexes off the student_course table, re-apply after inserts are completed.

Computergeek