3 Replies Latest reply: May 16, 2013 9:34 AM by Ebalthes-Oracle RSS

    Getting error while importing schema with ORACLE TEXT

    1009330
      IMP-00003: ORACLE error 20000 encountered
      ORA-20000: Oracle Text error:
      DRG-52204: error while registering index
      DRG-10507: duplicate index name: WORKORDER_Q, owner: SYS
      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.DRIIMP", line 115
      ORA-06512: at line 2
      IMP-00088: Problem importing metadata for index WORKORDER_Q. Index creation will be skipped



      Database version - Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      Os version - Linux nlxs1012.slb.atosorigin-asp.com 2.6.18-308.el5 #1 SMP Fri Jan 27 17:17:51 EST 2012 x86_64 x86_64 x86_64 GNU/Linux

      We have take export of schema from production db now importing data to qa environment..
      In import facing above error..