Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 8.1.7.0.0 coredump on import of split dmp file

Ramky99Nov 8 2010 — edited Nov 9 2010

Hi all,

I have an issue with importing into a 8.1.7.0.0 database.

Import string is:

imp file=bu20101027-23_01.dmp,bu20101027-23_02.dmp,bu20101027-23_03.dmp,bu20101027-23_04.dmp userid=xxx/xxx tables=TEST_TABLE show=y log=adam.log

..as you can see the export is in multiple files, each 2G in size. Looking at the export log the table I'm trying to import is spanned between the first two files:

. . exporting table TEST_TABLE
continuing export into file bu20101027-23_02.dmp

When I try to import it coredumps:

. . skipping table "ADAM_TEST" Segmentation fault(coredump)

There's nothing in the logfile, or Oracle alert log. Creates a core file, but nothing leaps out.

Any ideas? I've searched loads but not found anything specific to this.... and yes I know it's an old Oracle version, really need it to work though!

Thanks :)
Adam