ora-14098: what am I missing (long)

From: Gene Gurevich <g_u_r_e_v_i_c_h_at_yahoo.com>
Date: Fri, 14 Sep 2001 07:46:35 -0700
Message-ID: <F001.0038E879.20010914073022@fatcity.com>

!! Please do not post Off Topic to this List !!

Hi.

I'm getting ora-14098 error when executing the following command:

alter table rptg_cnt exchange partition p200107 with table xchg_rptg_cnt including indexes.

Usually when I see this error it means that either an index is missing on one of the tables or there is some discrepancy in terms of field order. This time around I can't see any difference. When I execute

SQL> select table_name, index_name, column_name   2 from user_ind_columns
  3 where table_name like '%RPTG_CNT'
  4 order by 1,2,column_position asc;

I see the same three indices with the same fields in each in the same order. I did a desc on both tables and all the fields have the same attributes. What am I missing here? Any ideas?

thanks

Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gene Gurevich
INET: g_u_r_e_v_i_c_h_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Sep 14 2001 - 09:46:35 CDT