我得到一个dmp并安装Oracle XE进行开发。但是,当我使用imp导入时,跳过了创建表语句。任何人都可以在这个问题上提供帮助。Oracle imp dmp文件,跳过创建表语句
屏幕输出被捕获如下:非常感谢!
C:\Documents and Settings\wong\Desktop>imp
Import: Release 10.2.0.1.0 - Production on Mon Aug 2 22:48:32 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: report
密码:
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio n
Import file: EXPDAT.DMP > report20100524.dmp
Enter insert buffer size (minimum is 8192) 30720> 30720
Export file created by EXPORT:V10.01.00 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 > yes
Import entire export file (yes/no): no
> yes
. impor