Maxim Demenko wrote:
> 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
Got it. That part of what you were saying wasn't obvious to me before.
--
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:59:25 CDT
