DA Morgan schrieb:
> 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.
Sorry ?
I've never said it can not be done, only what i said was: in
"ALTER TABLE abc EXCHANGE PARTITION efg WITH TABLE ijk"
both, TABLE abc AND TABLE ijk should be in the *SAME* database, it can
not be done over the database link.
Best regards
Maxim
Received on Wed Jun 29 2005 - 00:47:08 CDT