oracle exp&imp的报错

tonytang

source 环境  10.2.0.1.0+windows 2003  
object 环境   10.2.0.5.0+ redhat linux 5.5

需求导出导入一个用户，导出很正常 ，导入的时候报一下错误：

  IMP-00003: ORACLE error 29855 encountered
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-00955: name is already used by an existing object
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364
Import terminated successfully with warnings.


我另外贴出步骤和日志文件，请大家帮我看看哈。

Maclean Liu(刘相兵

ODM FINDING ;


Hdr: 6641649 10.2.0.3.0 DRGEN 10.2.0.3.0 PRODID-211 PORTID-23
Abstract: ORA-955: NAME IS ALREADY USED BY AN EXISTING OBJECT

*** 11/20/07 12:56 pm REQUEST TEXT ***

When creating two independent text indexes on two independent tables but
using the same storage preference we receive error:

ORA-955: name is already used by an existing object

when the storage preference names the LOB (the R_TABLE or the I_TABLE LOB)
This example shows it using R_TABLE_CLAUSE:

create table table1
(id number, text varchar2(50));

create table table2
(id number, text varchar2(50));


begin
ctx_ddl.create_preference('STORAGE_PREF','BASIC_STORAGE');
ctx_ddl.set_attribute('STORAGE_PREF','R_TABLE_CLAUSE','lob (data) store as
clob_r_data (disable storage in row cache)');
end;
/

create index ctx_idx1 on table1(text)
indextype is ctxsys.context
  parameters('storage STORAGE_PREF')
/

create index ctx_idx2 on table2(text)
indextype is ctxsys.context
  parameters('storage STORAGE_PREF')
/

/*

*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-955: name is already used by an existing object
ORA-6512: at "CTXSYS.DRUE", line 160
ORA-6512: at "CTXSYS.TEXTINDEXMETHODS", line 364
*/

/*



这似乎是一个 和 text index相关的bug ，


建议：

尝试用expdp /impdp 绕过该问题

xteitxu

ORA-00955: name is already used by an existing object
看样子你的库里已经有相同的object了

在导出脚本后加上 VERSION=10.2 导入试下。

tonytang

imp userid=express/express@wyncrac1 fromuser=express touser=express file=/oracle/rman_backup/express.dmp log=/oracle/rman_backup/express.log

导入的脚本