Home » SQL & PL/SQL » SQL & PL/SQL » possible to partition exchange two tables (oracle 9.2.0.8)
possible to partition exchange two tables [message #407145] Mon, 08 June 2009 12:48 Go to next message
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.
Re: possible to partition exchange two tables [message #407146 is a reply to message #407145] Mon, 08 June 2009 12:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No it is not possible.

Regards
Michel
Re: possible to partition exchange two tables [message #407152 is a reply to message #407145] Mon, 08 June 2009 13:02 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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.
Re: possible to partition exchange two tables [message #407279 is a reply to message #407152] Tue, 09 June 2009 07:17 Go to previous message
rleishman
Messages: 3724
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
Previous Topic: ORA-01045
Next Topic: Creating Hash Partition
Goto Forum:
  


Current Time: Tue Dec 06 16:24:04 CST 2016

Total time taken to generate the page: 0.12809 seconds