import of split files problem

[omegamark]

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]

[Kishore]

may be emp file is corrupted.

Try exporting again to the pipe and them import

[tamilselvan]

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]

[omegamark]

$ 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

[tamilselvan]

Could you pl. post the export script?

[omegamark]

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

[marist89]

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.