From oracle-l-bounce@freelists.org Mon Mar 1 16:23:14 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i21MNES05895 for ; Mon, 1 Mar 2004 16:23:14 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i21MNEo05889 for ; Mon, 1 Mar 2004 16:23:14 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9B417394EBB; Mon, 1 Mar 2004 17:23:55 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 01 Mar 2004 17:22:49 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8A412394E04 for ; Mon, 1 Mar 2004 17:22:46 -0500 (EST) Received: from comcast.net (host95.edocs.com[63.114.227.95]) by comcast.net (sccrmhc13) with ESMTP id <20040301222621016004bgtoe> (Authid: sramanujam); Mon, 1 Mar 2004 22:26:21 +0000 Message-ID: <4043B889.6030102@comcast.net> Date: Mon, 01 Mar 2004 17:26:17 -0500 From: Senthil Ramanujam User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: oracle-l@freelists.org Subject: Re: ORA - 14642 : partition exchange error References: <404368BC.7020409@comcast.net> <003b01c3ffaf$cee09410$6702a8c0@Primary> <404382BF.7000806@comcast.net> <008101c3ffc2$0a9e9850$6702a8c0@Primary> <40439441.3000204@comcast.net> <00b901c3ffd3$7eeb5480$6702a8c0@Primary> In-Reply-To: <00b901c3ffd3$7eeb5480$6702a8c0@Primary> Content-Type: text/plain; charset=us-ascii; format=flowed X-archive-position: 183 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sramanujam@comcast.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l That was useful. as always, appreciate your help. thanks jon. Jonathan Lewis wrote: >I've just compressed a table, and spare1 had >bit 17 (131072) set - so bit 16 must be something >else. I've got a note about it somewhere, I'm sure, >but can't find it. > >In the meantime, I've found your problem on Metalink >under document 248634.1 > >This includes the not null change as a possible >cause. > > >Regards > >Jonathan Lewis >http://www.jlcomp.demon.co.uk > >The Co-operative Oracle Users' FAQ >http://www.jlcomp.demon.co.uk/faq/ind_faq.html > >March 2004 Hotsos Symposium - The Burden of Proof > Dynamic Sampling - an investigation >March 2004 Charlotte OUG (www.cltoug.org) CBO Tutorial >April 2004 Iceland >June 2004 UK - Optimising Oracle Seminar > > >----- Original Message ----- >From: "Senthil Ramanujam" >To: >Sent: Monday, March 01, 2004 7:51 PM >Subject: Re: ORA - 14642 : partition exchange error > > > > >>Interesting...I dont think we have enabled or using this feature in our >>environment. let me double check my configurations. thanks again Jonathan. >> >> >> >> > > >---------------------------------------------------------------- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >---------------------------------------------------------------- >To unsubscribe send email to: oracle-l-request@freelists.org >put 'unsubscribe' in the subject line. >-- >Archives are at http://www.freelists.org/archives/oracle-l/ >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html >----------------------------------------------------------------- > > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------