ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 迁移表空间出错IMP-00032,IMP-00008

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

原创 Linux操作系统 作者:testmvb 时间:2010-01-28 15:37:51 0 删除 编辑
[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博客 ” ,链接:https://blog.itpub.net/10522540/viewspace-626246/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-02-23

  • 博文量
    51
  • 访问量
    176392