Home » SQL & PL/SQL » SQL & PL/SQL » Query regarding Exchange Partiiton
Query regarding Exchange Partiiton [message #290841] Tue, 01 January 2008 07:19 Go to next message
dr46014
Messages: 48
Registered: February 2007
Member
i am trying to perform a exchange partion with a fact table in our data base which is partiioned on the basis of month_code(200710,200711,200712,200801) like this..which is a range partiioned.Again the table is sub partioned on the basis of client_id(list partion).The fact table is having a global index on account_number.So if i do an exchange with a exchange table do i need to have the replica of same index and partion and sub partiion strategy on the exchage table.

please advise me if i can do any performance improvement using any other techinique


Regards,
Deepak
Re: Query regarding Exchange Partiiton [message #290844 is a reply to message #290841] Tue, 01 January 2008 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not clear what you have.
It would be better if you posted the DDL.
Now, exchange is surely the fastest way.

Regards
Michel
Re: Query regarding Exchange Partiiton [message #290847 is a reply to message #290844] Tue, 01 January 2008 08:20 Go to previous messageGo to next message
dr46014
Messages: 48
Registered: February 2007
Member
For the exchange table do i need to have the same index strategy as that of main target table ?
what i believe the table which is going to be exchaged with a partition in the target table doesnot have any indexes and partitions on it.
Re: Query regarding Exchange Partiiton [message #290850 is a reply to message #290847] Tue, 01 January 2008 08:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restrictions depend on your version but in short yes.
Refer to your documentation.

SQL Reference
ALTER TABLE page
exchange_partition_subpart section

Regards
Michel

[Updated on: Tue, 01 January 2008 08:31]

Report message to a moderator

Re: Query regarding Exchange Partiiton [message #291052 is a reply to message #290850] Wed, 02 January 2008 20:37 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The exact scenrio you are after is covered in the Data Warehousing Guide.

Ross Leishman
Previous Topic: Rollback a committed trans
Next Topic: Diffrence between 'IS' and 'AS' in Procedure creation
Goto Forum:
  


Current Time: Sun Dec 04 04:57:50 CST 2016

Total time taken to generate the page: 0.16690 seconds