迁移表空间出错IMP-00032,IMP-00008

[oracle@datawarehouse ~]$ imp '"/ as sysdba"' file='/home/oracle/BOBO.dmp' transport_tablespace=Y TABLESPACES=YDBILL_TRANS_TBS DATAFILES=('/storage/u03/msbi/YD_BILL_01.DBF','/storage/u03/msbi/YD_BILL_02.DBF','/storage/u03/msbi/YD_BILL_03.DBF','/storage/u03/msbi/YD_BILL_04.DBF','/storage/u03/msbi/YD_BILL_05.DBF');

Import: Release 10.2.0.1.0 - Production on 星期三 1月 27 16:50:38 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

IMP-00002: failed to open /home/oracle/BOBO.dmp for read
Import file: expdat.dmp > '/home/oracle/BOBO.DMP'

IMP-00002: failed to open '/home/oracle/BOBO.DMP' for read
Import file: expdat.dmp > /home/oracle/BOBO.DMP

Export file created by EXPORT:V10.02.01 via conventional path
About to import transportable tablespace(s) metadata...
import done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. importing SYS's objects into SYS
. importing SYS's objects into SYS
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
   DBMS_STATS.NUMARRAY(
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file:
  REC.MINVAL := '303030313033313333333430'; SREC.MAXVAL := '393939393033313135343034'; SREC.EAVS := 0; SREC.CHVALS := NULL; #
Import terminated successfully with warnings.
查询发现表空间已经建立，但是对象未建立。
将空间DROP掉，修改缓冲区为20480000，导入未出现错误。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10522540/viewspace-626246/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10522540/viewspace-626246/