Re: Does Partition DDL generate redologs?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 28 Jun 2005 22:37:11 -0700
Message-ID: <1120023434.928653@yasure>

Maxim Demenko wrote:
> DA Morgan schrieb:
>

>> Maxim Demenko wrote:
>>
>>> Maybe i misunderstood your intention, but if you are going to 
>>> exchange partitions with tables in different databases - it is not 
>>> implemented yet ;-)
>>>
>>> Best regards
>>>
>>> Maxim
>>
>>
>>
>> Unless I am misunderstanding you, and the OP, it most certainly is.
>>
>> Might I ask for a clarification of what you think can not be done.
>>
>> Thanks.

>
>
> It seems to be not too good time for clarifications ( after at least 6
> cups of coffee ;-)), but that is my point:
>
> Op states
> ALTER TABLE E1 EXCHANGE PARTITION P1 WITH TABLE STAGE.E1_STAGE_at_STAGE;
>
> This implies ( as for me ) he will exchange a partition of local
> partitioned table with a table on remote database, which should end up
> in 0RA-02021 -- ddl operations on remote database are not allowed. It is
> obvious , that exchange partition is only data dictionary operation
> that doesn't lead to data movement, it switches only segment pointers.
> Further , i'm afraid , OP misunderstood the concept of such partitioning
> operations , because he will reduce the amount of redo generated ( which
> is in this case insignificant compared with insert in the table contents
> of an partition ).
> Maybe Daniel, you can tell me your point of view on this subject, anyway
> , still ready to learn ...
>
> Best regards
>
> Maxim

 From Morgan's Library:

Convert A Partition Into A Stand-alone Table ALTER TABLE sales
EXCHANGE PARTITION feb97 WITH TABLE sales_feb97 INCLUDING INDEXES
WITHOUT VALIDATION
EXCEPTIONS INTO uwclass.problems;

One can also convert a stand-alone table into a partition of a partitioned table.

So I'm seeing the ability to go either way and am trying to figure out what you are saying can not be done.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Wed Jun 29 2005 - 00:37:11 CDT