!! Please do not post Off Topic to this List !!
Please ignore the previous post. It turned out that
one of the indices on the partitioned table was not
partitioned locally. That's what I was missing
- Gene Gurevich <g_u_r_e_v_i_c_h_at_yahoo.com> wrote:
> 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/
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-unsubscribe_at_LAZYDBA.com
> To subscribe: send a blank email to
> oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
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 - 10:03:29 CDT
