import of split files problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: import of split files problem

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    export dump files are xaa xab xac xad xae

    mknod /dbbackup/imp_pipe p
    cat xaa xab xac xad xae >/dbbackup/imp_pipe &


    $ imp system/password file=/dbbackup/imp_pipe show=y ful
    l=y log=a.sql buffer=6565656

    Import: Release 8.1.6.3.0 - Production on Tue Mar 19 10:49:59 2002

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


    Connected to: Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.3.0 - Production

    IMP-00037: Character set marker unknown
    IMP-00000: Import terminated unsuccessfully
    [1] + Broken Pipe cat xaa xab xac xad xae > /dbbackup/imp_pipe &

    can u pls say where I am wrong

    [Edited by omegamark on 03-19-2002 at 10:56 AM]
    Radhakrishnan.M

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    may be emp file is corrupted.

    Try exporting again to the pipe and them import
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What are the file sizes of xaa, xab...?
    If each dump file size is > 2GB, then your import may not work.

    If NLS_LANGUAGE setup in your environment is different from the DB, you may get this error.


    [Edited by tamilselvan on 03-19-2002 at 12:48 PM]

  4. #4
    Join Date
    Sep 2000
    Posts
    384
    $ NLS_LANG=AMERICAN_AMERICA.US7ASCII
    $ export NLS_LANG
    $ mknod imp_pipe p
    $ cat xaa xab xac xad xae > imp_pipe &
    [1] 27840
    $ imp userid=system/password file=imp_pipe show=y full=y log=a.sql buffer=6565656

    Import: Release 8.1.6.3.0 - Production on Tue Mar 19 13:55:11 2002

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


    Connected to: Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.3.0 - Production

    no error .it is just hannging
    Radhakrishnan.M

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Could you pl. post the export script?


  6. #6
    Join Date
    Sep 2000
    Posts
    384
    nohup split -b 1000m < /dev/split_pipe &

    exp parfile=/data/expsprd.parm


    expsprd.parm
    USERID=system
    FULL=N
    OWNER=sprd
    COMPRESS=N
    GRANTS=Y
    INDEXES=Y
    ROWS=Y
    CONSTRAINTS=Y
    LOG=/data/sprd_exp.log
    FILE=/dev/split_pipe
    DIRECT=N
    STATISTICS=none
    FEEDBACK=1000000
    BUFFER=409600
    Radhakrishnan.M

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    That should work. Where I've gotten bitten before by this is by specifying the split files in the wrong order during the pipe creation.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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