导入操作时出现如下情况,有雷同及解决的大侠帮忙解答一下
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 9 16:17:32 2012Copyright (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 optionsSQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>
Table truncated.Elapsed: 00:00:00.20
SQL>
Commit complete.Elapsed: 00:00:00.00
SQL> SQL>
Table truncated.Elapsed: 00:00:00.22
SQL>
Commit complete.Elapsed: 00:00:00.01
SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsImport: Release 10.2.0.4.0 - Production on Tue Oct 9 16:17:33 2012Copyright (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
. importing DB_ACCOUNT_INFO's objects into DB_ACCOUNT_INFO
. . importing table "SYS_BRANCH_BRANCH"
721 rows imported
. . importing table "SYS_BRANCH_TMPBCH"
755 rows imported
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00008: unrecognized statement in the export file:
u
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00008: unrecognized statement in the export file:
u
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00008: unrecognized statement in the export file:
u
Import terminated successfully with warnings.
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 9 16:17:32 2012Copyright (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 optionsSQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL>
Table truncated.Elapsed: 00:00:00.20
SQL>
Commit complete.Elapsed: 00:00:00.00
SQL> SQL>
Table truncated.Elapsed: 00:00:00.22
SQL>
Commit complete.Elapsed: 00:00:00.01
SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsImport: Release 10.2.0.4.0 - Production on Tue Oct 9 16:17:33 2012Copyright (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
. importing DB_ACCOUNT_INFO's objects into DB_ACCOUNT_INFO
. . importing table "SYS_BRANCH_BRANCH"
721 rows imported
. . importing table "SYS_BRANCH_TMPBCH"
755 rows imported
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00008: unrecognized statement in the export file:
u
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00008: unrecognized statement in the export file:
u
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00008: unrecognized statement in the export file:
u
Import terminated successfully with warnings.
SQL>alter system set events='942 trace name errorstack';
执行imp导入数据
在目录<USER_DUMP_DEST>下找出刚生成的trace文件处理完了再关闭
SQL> alter system set events='942 trace name errorstack off';