首先运行 cmd
然后:
C:\Documents and Settings\wzq>imp
Import: Release 10.2.0.1.0 - Production on 星期日 11月 7 13:29:39 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
分别输入 用户名 密码
Username: hr
Password:
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
下面提示你 输入 要导入的 dmp 文件名
Import file: EXPDAT.DMP >
Enter insert buffer size (minimum is 8192) 30720>
Export file created by EXPORT:V10.02.01 via conventional path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
这里问,是否仅仅列内容,不导入
List contents of import file only (yes/no): no >
这里问 如果对象已经存在了, 是否忽略创建的错误
Ignore create error due to object existence (yes/no): no >
这里问,是否导入权限
Import grants (yes/no): yes > no
这里问,是否导入表数据
Import table data (yes/no): yes >
这里问,是否导入整个文件
Import entire export file (yes/no): no > yes
. importing HR's objects into HR
. importing HR's objects into HR
. . importing table "A" 8 rows imported
Import terminated successfully without warnings.
然后就结束了。