Re: Does Partition DDL generate redologs?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 29 Jun 2005 03:19:16 +0200
Message-ID: <d9ssuj$vim$05$1@news.t-online.com>

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 Received on Tue Jun 28 2005 - 20:19:16 CDT