本文介绍在Oracle Database 10g中进行表空间重映射(REMAP_TABLESPACE)操作时遇到ORA-39001及ORA-39046错误的情况。文中解释了错误产生的原因，并提供了不同版本间正确的使用语法。
Import: Release 10.2.0.4.0 - 64bit Production on Wednesday, 22 January, 2014 15:35:42
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-39001: invalid argument value
ORA-39046: Metadata remap REMAP_TABLESPACE has already been specified.
11g & abover:
REMAP_TABLESPACE=old_A:new_A
REMAP_TABLESPACE=old_B:new_B
REMAP_TABLESPACE=old_A:new_A
REMAP_TABLESPACE=old_B:new_B
10g:
REMAP_TABLESPACE=old_A:new_A,old_B:new_B
REMAP_TABLESPACE=old_A:new_A,old_B:new_B
if old_A & old_B are the same, then will alert this error.
扫一扫
1971
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
