I have several tables exported from our database and I'm trying to import it on another database of the same version.
IMP was able to import all rows of the table GRADESYSOL_FOR_REGISTRATION but it apparently hangs when it reaches the table STUDENT.
IMP log is generated but contains no text.
I tried restarting the target machine but no joy.
I tried a guess, thinking it was in the buffer size so I tried changing it from default 30720 to 122880 but no joy.
I tried isolating the tables. The other tables were imported without warnings/errors (except the REGULAR_SUBJECT_ENROLLED and
STUDENT_COURSE_RECORD which I didn't try because they have foreign keys from the student table).
Also, I noticed that when the imp hangs, it seems to have created the student table and inserted 3 rows. I thought it was taking too long so I look again after several minutes, and saw 70 rows inserted. Next time I visited, it was more than 100 (can't remember the exact figure). I killed (CTRL+C) the command because it seems to be taking too long to just import this table which was not like that before we took our vacation.
And so I went here for help. I don't know what to do.. ^_^
Below is the export log of the dump, if it may help. Machine of both databases are Windows 2003.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified tables via Direct Path ...
. . exporting table GRADESYSOL_FOR_REGISTRATION 3193 rows exported
Table STUDENT will be exported in conventional path.
. . exporting table STUDENT 46407 rows exported
. . exporting table STUDENT_COURSE_RECORD 56993 rows exported
. . exporting table REGULAR_SUBJECT_ENROLLED 1508960 rows exported
. . exporting table OFFERING 81021 rows exported
. . exporting table SUBJECT 21881 rows exported
. . exporting table CURRICULUM 328 rows exported
. . exporting table DEGREE 118 rows exported
. . exporting table COURSE 111 rows exported
. . exporting table DEPARTMENT 35 rows exported
. . exporting table COLLEGE 11 rows exported
. . exporting table GRADING_SYSTEM 1696 rows exported
. . exporting table EMPLOYEE 837 rows exported
. . exporting table CURRENT_SYEAR_SEMESTER 1 rows exported
. . exporting table OSCH_SUBJECT_ENROLLED 25384 rows exported
Export terminated successfully without warnings.