OraFAQ Forum: SQL & PL/SQL » possible to partition exchange two tables

Home » SQL & PL/SQL » SQL & PL/SQL » possible to partition exchange two tables (oracle 9.2.0.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

possible to partition exchange two tables [message #407145]

Mon, 08 June 2009 12:48

goo321
Messages: 28
Registered: June 2008
Location: houston

Junior Member

Is it possible to partition exchange without partitions?

That is partition exchange two unpartitioned tables?

I think renaming tables would lead to invalid dependent code units.
It would be possible to have an intermediary partitioned table and partition exchange twice without validation.

Thanks.
goo.

Report message to a moderator

Re: possible to partition exchange two tables [message #407146 is a reply to message #407145]

Mon, 08 June 2009 12:49

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No it is not possible.

Regards
Michel

Report message to a moderator

Re: possible to partition exchange two tables [message #407152 is a reply to message #407145]

Mon, 08 June 2009 13:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I think renaming tables would lead to invalid dependent code units.
Code automagically gets recompiled upon next reference.

Report message to a moderator

Re: possible to partition exchange two tables [message #407279 is a reply to message #407152]

Tue, 09 June 2009 07:17

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Your could exchange non-partitioned tables A and B in a two-part process via non-partitioned table C.

Exchange A with a partition of C
Exchange B with the same partition of C

Ross Leishman

Report message to a moderator

Previous Topic:	ORA-01045
Next Topic:	Creating Hash Partition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 16:57:01 CST 2024