Index failing on import
From: J. Dex <cemail_219_at_hotmail.com>
Date: Thu, 12 Mar 2009 17:33:03 -0400
Message-ID: <BLU147-W16210F7B5CB05029C6EFCDA59F0_at_phx.gbl>
Windows Live™ Groups: Create an online spot for your favorite groups to meet. http://windowslive.com/online/groups?ocid=TXT_TAGLM_WL_groups_032009
Date: Thu, 12 Mar 2009 17:33:03 -0400
Message-ID: <BLU147-W16210F7B5CB05029C6EFCDA59F0_at_phx.gbl>
I did an import and got the error below. When I look through OEM, it looks like the index is there. However, when I run analyze index <schema>.IDX_IDXNNN validate structure; it says the specified index does not exist. Is there any way to fix this without dropping and recreating the index?
IMP-00017: following statement failed with ORACLE error 20000: "BEGIN DBMS_STATS.SET_INDEX_STATS IMP-00003: ORACLE error 20000 encountered ORA-20000: Unable to set values for index IDX_IDXNNN: does not exist or insufficient privileges
Windows Live™ Groups: Create an online spot for your favorite groups to meet. http://windowslive.com/online/groups?ocid=TXT_TAGLM_WL_groups_032009
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 12 2009 - 16:33:03 CDT