Re: Partition Exchange Newbie Question

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 16 Jul 2013 12:41:01 -0500
Message-ID: <CAP79kiSoBR1RzJ76mRj=5OQ3KQ6fGFot9qREXeoqjDd_mR88qg_at_mail.gmail.com>

Thanks for the input. I thought Oracle would give me a nice trapped error if Global Temporary Tables couldn't be used, but instead of I get a nice ORA-600 error in 10.2.0.4 :)
Glad you told me that GTTs can't be used for partition exchange. It makes sense when I think about Oracle operating on the segments themselves and not the data in those segments. I was under the impression it was moving the data (versus the physical segment).
Thanks again.

Chris

P.S. Here is the ORA error in 10.2.0.4 Linux when trying against Global Temporary Table:
ORA-00600: internal error code, arguments: [ktsircinfo_num1], [2147483647], [1024], [0], [], [], [], []

On Tue, Jul 16, 2013 at 12:03 PM, Fergal Taheny <ftaheny_at_gmail.com> wrote:

> Hi Chris,
>
> You wont be able to use a global temporary table as that will have its
> segment in temp. With partition exchange you are swopping the segments
> associated with a table/partition. So you need to use a real table and yes
> you will need a table for each partition or load the partitions one at a
> time
>
> Regards,
> Fergal
> On 16 Jul 2013 17:37, "Chris Taylor" <christopherdtaylor1994_at_gmail.com>
> wrote:
>
>> I want to test a partition exchange as an alternative method of doing some
>> work in the database.
>>
>>
>> I was thinking about loading a global temporary table with the data and
>> then doing the exchange however I'm curious about the following:
>>
>>
>>
>> Let's say that Primary Partitioned Table is like this:
>>
>>
>>
>> Table_Name, Partition_Name, Values
>>
>> TABLEA......Values1.........Values < 10000
>>
>> TABLEA......Values2.........Values < 20000
>>
>> TABLEA......Values3.........Values < 30000
>>
>>
>>
>> Now, if I load my TEMP table with **all** values, can I do a partition
>> exchange and have the values automatically go into the correct partitions
>> of the main partitioned table
>>
>> **OR**
>>
>> Do we have to load the temp table with each set of values and do the
>> partition exchange one set of values at a time?
>>
>>
>>
>> I hope that question is clear enough, if not I can try to put together a
>> more detailed example of what I'm trying to ask.
>>
>>
>>
>> Regards,
>>
>>
>>
>> *Chris D. Taylor*
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 16 2013 - 19:41:01 CEST