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" <sramanujam@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------