首页 » ORACLE » IMP-00046: using FILESIZE value from export

IMP-00046: using FILESIZE value from export

[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

打赏

对不起,这篇文章暂时关闭评论。