Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

imp-00037

451600Jul 11 2006 — edited Jul 11 2006
My export file is not corrupt. however I am getting this error.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options

IMP-00037: Character set marker unknown
IMP-00000: Import terminated unsuccessfully

here is the shell script:
#!/bin/ksh
#
#

PATH=$PATH:$HOME/bin

# Oracle Environment
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/10.1.0/db_1

PATH=$PATH:$HOME/bin

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

export LD_LIBRARY_PATH

# Set Shell search path

export PATH=$PATH:$ORACLE_HOME/bin

export PATH
EXP_DIR=/ora_backup/live
ORATAB=/etc/oratab
. oraenv <<EOF 1>/dev/null 2>&1
live
EOF
#
mknod CONVERT.p p
#
gunzip < $EXP_DIR/fullexp_dpr1010.gzip > CONVERT.p &
$ORACLE_HOME/bin/imp parfile=fullexp_dpr1010.parm <<EOF
username/pass@live
EOF
#
rm CONVERT.p

What should I do?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 8 2006
Added on Jul 11 2006
4 comments
476 views