[oracle@aix backup]$ imp system/oracle fromuser=topbox touser=zwz file=192.168.212.42_topbox01.2011-06-20.dmp,192.168.212.42_topbox02.2011-06-20.dmp tables=
topbox_userstudyinfo
Import: Release 10.2.0.4.0 - Production on Fri Jun 24 10:40:10 2011
Copyright (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 options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by HYSH, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
IMP-00046: using FILESIZE value from export file of 25165824000Killed
[oracle@aix ~]$ oerr imp 46
00046, 00000, "using FILESIZE value from export file of %s"
// *Cause: Either you did not specify the FILESIZE parameter in your
// IMPORT command, or you specified FILESIZE=0 and the export file
// was created with a non-zero value for FILESIZE. Import will use
// the value specified in the export file.
// *Action: None required.
如果imp 无法结整 ,kill pid
[oracle@aix backup]$ imp system/oracle fromuser=topbox touser=zwz file=192.168.212.42_topbox01.2011-06-20.dmp,192.168.212.42_topbox02.2011-06-20.dmp tables=
topbox_userstudyinfo filesize=25165824000
Import: Release 10.2.0.4.0 - Production on Fri Jun 24 10:52:21 2011
Copyright (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 options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by HYSH, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing TOPBOX's objects into ZWZ
. . importing table "TOPBOX_USERSTUDYINFO" 1136664 rows imported
----部份省略---
note: if export specify the FILESIZE parameter,so when you import specify TABLES parameter and you must specify the FILESIZE same ths export filesize too
topbox_userstudyinfo
Import: Release 10.2.0.4.0 - Production on Fri Jun 24 10:40:10 2011
Copyright (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 options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by HYSH, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
IMP-00046: using FILESIZE value from export file of 25165824000Killed
[oracle@aix ~]$ oerr imp 46
00046, 00000, "using FILESIZE value from export file of %s"
// *Cause: Either you did not specify the FILESIZE parameter in your
// IMPORT command, or you specified FILESIZE=0 and the export file
// was created with a non-zero value for FILESIZE. Import will use
// the value specified in the export file.
// *Action: None required.
如果imp 无法结整 ,kill pid
[oracle@aix backup]$ imp system/oracle fromuser=topbox touser=zwz file=192.168.212.42_topbox01.2011-06-20.dmp,192.168.212.42_topbox02.2011-06-20.dmp tables=
topbox_userstudyinfo filesize=25165824000
Import: Release 10.2.0.4.0 - Production on Fri Jun 24 10:52:21 2011
Copyright (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 options
Export file created by EXPORT:V10.02.01 via conventional path
Warning: the objects were exported by HYSH, not by you
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing TOPBOX's objects into ZWZ
. . importing table "TOPBOX_USERSTUDYINFO" 1136664 rows imported
----部份省略---
note: if export specify the FILESIZE parameter,so when you import specify TABLES parameter and you must specify the FILESIZE same ths export filesize too
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
