Importing from multiple dumps
How do I import multiple dumps into one schema in the same import?
The imp command I used is as follows:
imp system/**** file=ml0.dmp,ml1.dmp,ml2.dmp,ml3.dmp,ml4.dmp parfile=imp_maskop.par log=imp_maskop.log
Here is the parameter file:
fromuser=AM
touser=MASKOP
ignore=Y
rows=Y
tables=(ACTIVITY_LOG, ACTIVITY_RESULT, FILE_REC, JOB, LETTER)
filesize=629145600
(filesize was specified in the export. So I am using that here as well, without which I was getting another error)
Here is what I see when I run the import:
Export file created by EXPORT:V08.01.06 via conventional path
Warning: the objects were exported by AM, not by you
import done in UTF8 character set and AL16UTF16 NCHAR character set export client uses US7ASCII character set (possible charset conversion) export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
. importing AM's objects into MASKOP
. . importing table "ACTIVITY_LOG"./imp_softshoe.sh: 21061756 Memory fault(coredump)
The import starts and errors with a core dump.
The export log says the following:
Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table ACTIVITY_LOG 169272 rows exported
. . exporting table ACTIVITY_RESULT 49 rows exported
. . exporting table FILE_REC 64 rows exported
. . exporting table JOB 30052 rows exported
. . exporting table LETTER 31 rows exported
. . exporting table PERSON
continuing export into file ml1.dmp
continuing export into file ml2.dmp
continuing export into file ml3.dmp
continuing export into file ml4.dmp
535875 rows exported
. . exporting table RES_SUBMIT_HISTORY 858323 rows exported
. . exporting table USER_REC 879 rows exported
Export terminated successfully without warnings.
So, why the core dump error? What am I doing wrong in running the import if anything? Thanks.
