3 Replies Latest reply on May 16, 2013 2:34 PM by Ebalthes-Oracle

    Getting error while importing schema with ORACLE TEXT

      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 - 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..