- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-12 18:30:20
|
查看: 1964 |
回复: 0
刚刚接触oracle不久,最近做window 32位系统下数据库(oracle10g)到 linux 64位系统(oracle11g)的表空间迁移,遇到如下问题:
将数据从原库中通过rman工具命令transport tablespace导出后,上传至linux系统中,执行impdp导入出现如下问题:
$ impdp system/xxxxx@xxx directory=dumpdir dumpfile='DMPFILE.DMP' transport_datafiles=/oracle/ora11g/oradata/elms/PERFSTAT01.DBF,/oracle/ora11g/oradata/elms/USERS001.DBF,/oracle/ora11g/oradata/elms/TBS_ELMS_8610_DEV_PRD01.DBF logfile=imp_8610_three.log
Import: Release 11.2.0.3.0 - Production on Sat Jan 5 10:20:24 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" failed to load/unload
ORA-31640: unable to open dump file "/oracle/ora11g/oradata/elmsdg/DMPFILE.DMP" for read
ORA-19505: failed to identify file "/oracle/ora11g/oradata/elmsdg/DMPFILE.DMP"
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
请高手们帮忙看看,是怎么回事啊,我在window下执行导入时,可正常导入,但是编译(utlirp.sql)是又有报错:select to_number('must_be_open_upgrade')from v$instance where status !='open migrate'--------ora-01722:无效的数字。 |
|