Stupid import question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Stupid import question

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    3,131

    Talking

    Ok, how do we specify an import if the export uses multiple .DMP files?

    In the parfile will the syntax be

    File=D:\blah1
    File=D:\blah2


    I can't find this syntax and I'd like to get this squared away soon since I have to run this into production in about 10 minutes.

    Thanks guys;

    MH
    I remember when this place was cool.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    that should work

    import_xyz.sh
    ::::::::::::::
    imp user/***@xyz \
    file=/export/oracle/xyz1.dmp, \
    /export/oracle/xyz2.dmp, \
    export/oracle/xyz3.dmp \
    fromuser=xyz touser=xyz ignore=y \
    tables=xyz \
    buffer=102485760 \
    log=import_xyz.log \
    commit=y \
    feedback=10000

    [Edited by sreddy on 08-07-2002 at 02:59 PM]
    Reddy,Sam

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Do export of table using FIELSIZE parameter.

    [tiger5]/u08/users/sadavid/SD815> exp sadavid/sadavid tables=test_table
    file=sadavid.dmp log=exp1.log filesize=50K

    Export: Release 8.1.5.0.0 - Production on Thu Oct 14 15:43:05 1999

    (c) Copyright 1999 Oracle Corporation. All rights reserved.


    Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production
    Export done in US7ASCII character set and US7ASCII NCHAR character set

    About to export specified tables via Conventional Path ...
    . . exporting table TEST_TABLE
    Export file: expdat.dmp > sadavid1.dmp

    continuing export into file sadavid1.dmp

    Export file: expdat.dmp > sadavid2.dmp

    continuing export into file sadavid2.dmp

    Export file: expdat.dmp > sadavid3.dmp

    continuing export into file sadavid3.dmp

    Export file: expdat.dmp > sadavid4.dmp

    continuing export into file sadavid4.dmp

    Export file: expdat.dmp > sadavid5.dmp

    continuing export into file sadavid5.dmp
    2693 rows exported
    Export terminated successfully without warnings.
    [tiger5]/u08/users/sadavid/SD815>


    4. Truncate test_table and then do import.

    *NOTE: If you do not use FILESIZE=50K in your import, you will
    get an IMP-00046: using FILESIZE value from export file
    of 51200 but the import does complete successfully.

    [tiger5]/u08/users/sadavid/SD815> imp sadavid/sadavid file=sadavid.dmp
    tables=test_table ignore=y log=imp1.log

    Import: Release 8.1.5.0.0 - Production on Thu Oct 14 16:04:11 1999

    (c) Copyright 1999 Oracle Corporation. All rights reserved.


    Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production

    Export file created by EXPORT:V08.01.05 via conventional path
    import done in US7ASCII character set and US7ASCII NCHAR character set
    IMP-00046: using FILESIZE value from export file of 51200
    . importing SADAVID's objects into SADAVID
    . . importing table "TEST_TABLE"
    Import file: expdat.dmp > sadavid1.dmp

    Enter name of the next file in the export file set.
    Import file: expdat.dmp > sadavid2.dmp

    Enter name of the next file in the export file set.
    Import file: expdat.dmp > sadavid3.dmp

    Enter name of the next file in the export file set.
    Import file: expdat.dmp > sadavid4.dmp

    Enter name of the next file in the export file set.
    Import file: expdat.dmp > sadavid5.dmp
    2693 rows imported
    Import terminated successfully with warnings.
    [tiger5]/u08/users/sadavid/SD815>



    you dont specify each file's name you specify the export file name specified when you export

    but seems like there are several ways of doing it, check Note 75109.1

    [Edited by pando on 08-07-2002 at 02:59 PM]

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    file=file1.dmp,file2.dmp,etc.

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    THANKS guys, you just saved me some mild headaches.
    I am doing europe production now. The ONLY reason we need multiples on this NT box is because winzip can not zip files larger than 4 Gigs.

    Thanks Again, you guys rock!

    MH
    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