linux下导入.dmp文件
(2012-10-12 14:15:51)
标签：
it
[oracle@localhost script]$ imp
Import: Release 8.1.7.4.0 - Production on Mon Feb 9 13:59:02
2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Username: cams --此处输入启动导入的用户
Password: --此处输入相应的密码
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0
-Production
JServer Release 8.1.7.4.0 - Production
Import file: expdat.dmp > /tmp/2004020601.dmp
--此处输入需要导入的文件名,如果导出数据时导出到了多个文件,
则imp 会提示用户需要输入下一个需要导入的文件名.交互式导入时大多数参数都有缺省值.如果选用缺省值,直接回车即可.
Enter insert buffer size (minimum is 8192) 30720>
--此处需要输入buffer值,此处通常选择缺省值,直接回车.
Export file created by EXPORT:V08.01.07 via conventional
path
import done in ZHS16CGB231280 character set and ZHS16CGB231280
NCHAR
character set
IMP-00046: usi
