#.bash_profile 内容如下:
# Oracle Environment
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/9.2.0
export ORACLE_SID=orcl
export ORACLE_TERM=xterm
#export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
#set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/td/lib:/usr/ucblib:/usr/local/lib
export LD_LIBRARY_PATH
# Set shell search paths:
PATH=/bin:/usr/bin:/usr/sbin:/etc:/opt/bin:/usr/ccs/bin:/usr/openwin/bin:/opt/local/GNU/bin
PATH=$PATH:/opt/local/bin:/opt/NSCPnav/bin:$ORACLE_HOME/bin
PATH=$PATH:/usr/local/samba/bin:/usr/ucb:
export PATH
# CLASSPATH must include the following JRE locations:
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
导入数据时,出错,tang 用户为DBA,应该是不会出现Warning: the objects were exported by INN, not by you
错误才对.
请各位高手帮忙解决.
[oracle@crm oracle]$ imp tang/sa file=cn_yoyaku_data.dmp
Import: Release 9.2.0.1.0 - Production on Tue Jan 5 17:47:18 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connec