Importing from multiple dumps
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Importing from multiple dumps

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    138

    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.

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    I don't see anything that stands out that would cause the core dump (at least in your syntax)
    Are you getting any trace files generated in the udump dir?
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Jan 2001
    Posts
    138
    No. There are no trace files in udump.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    In my windoze experience you need to specify the complete path to every .DMP file.

    Ex...

    FILE=
    D:\yo_momma\dave_is_ugly_1.dmp,
    D:\yo_momma\dave_is_ugly_2.dmp,
    D:\yo_momma\dave_is_ugly_3.dmp

    Know what I mean Vern?
    Last edited by Mr.Hanky; 05-19-2006 at 05:01 PM.
    I remember when this place was cool.

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Hi Hanky!

    How d'you think yer boy's doing?


    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    Quote Originally Posted by slimdave
    Hi Hanky!

    How d'you think yer boy's doing?



    Not bad, I take him with me wherever (and whenever) I go.
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width