-
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]
-
may be emp file is corrupted.
Try exporting again to the pipe and them import
-
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]
-
$ 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
-
Could you pl. post the export script?
-
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
-
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.