各位好,以下是IMP过程信息,
最后显示成功终止,但数据库内无记录.恳请高人指点.
$ imp system/manager file=/zpsora/exp56201.dmp fromuser=system touser=crm ignore=y feedback =100000 commit=yImport: Release 10.2.0.4.0 - Production on Thu Apr 16 18:08:53 2009Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V10.02.01 via direct path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Import terminated successfully without warnings.
$
最后显示成功终止,但数据库内无记录.恳请高人指点.
$ imp system/manager file=/zpsora/exp56201.dmp fromuser=system touser=crm ignore=y feedback =100000 commit=yImport: Release 10.2.0.4.0 - Production on Thu Apr 16 18:08:53 2009Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsExport file created by EXPORT:V10.02.01 via direct path
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
Import terminated successfully without warnings.
$
你是否把connect,resource 权限赋给crm(如果crm没有相应权限的话,有时候也看不到数据)
看看要导的目的地方有空间没？
2、dmp数据
3、full=y,ignore=y