Re: ORA - 14642 : partition exchange error

From: Senthil Ramanujam <sramanujam_at_comcast.net>
Date: Mon, 01 Mar 2004 14:51:29 -0500
Message-ID: <40439441.3000204@comcast.net>

Interesting...I dont think we have enabled or using this feature in our environment. let me double check my configurations. thanks again Jonathan.

SQL> select * from dba_tablespaces where tablespace_name = 'XXXXXXXX';

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT

MIN_EXTENTS
------------------------------ ---------- -------------- -----------

MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
----------- ------------ ---------- --------- --------- --------- ---

ALLOCATIO PLU SEGMEN
--------- --- ------

XXXXXXXX                             4096        1048576     
1048576           1
 2147483645            0    1048576 ONLINE    PERMANENT LOGGING   NO  LOCAL

UNIFORM NO MANUAL SQL> select * from dba_data_files where tablespace_name = 'XXXXXXXX';

FILE_NAME

   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS


---------- ------------------------------ ---------- ---------- ---------

RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
/u3/oradata/beta/data/xxxxxxxx_01.dbf

         3 XXXXXXXX                        922746880     225280 AVAILABLE
           3 YES 1.7180E+10    4194302            1  921698304      225024

SQL> Jonathan Lewis wrote:

>Are you doing your tests in tablespaces with
>segment compression enabled ?  You have
>bit 16 set, and I think that's the 'compressed
>segment' bit.
>
>      65900 = 65536 + 364
>
>Something has set the bit unexpectedly, which
>has confused the issue.
>
>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_at_comcast.net>
>To: <oracle-l_at_freelists.org>
>Sent: Monday, March 01, 2004 6:36 PM
>Subject: Re: ORA - 14642 : partition exchange error
>
>
>  
>
>>i checked tab$.spare1 column and this is what i got back. Thanks a lot 
>>jonathan.
>>
>>-- a table with char(4)
>>SQL> r
>>  1  select spare1
>>  2  from tab$, dba_objects do
>>  3  where do.object_id = tab$.obj#
>>  4* and  do.object_name = 'PT'
>>
>>    SPARE1
>>----------
>>       364
>>
>>-- a table with char(5)
>>SQL> r
>>  1  select spare1
>>  2  from tab$, dba_objects do
>>  3  where do.object_id = tab$.obj#
>>  4* and  do.object_name = 'PT'
>>
>>    SPARE1
>>----------
>>     65900
>>
>>SQL>
>>
>>
>>    
>>
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to:  oracle-l-request_at_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_at_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


-----------------------------------------------------------------

Received on Mon Mar 01 2004 - 13:48:44 CST