!! 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
