Re: Federated & Merge
Hi Justin -
I've seen a something that addresses your query. Instead of a MERGE table, you'll create a VIEW which uses a select ... union ... union ... to include all the tables that you want included in the merge. The federated tables can be included in the view's union.
Sorry I don't have the exact page, but search for "Data Archiving Techniques" which shows a page that talks about combining archive tables in a view (ie how we would use merge in MySQL 4).
Cheers,
Dean
Subject
Views
Written By
Posted
6780
March 28, 2005 07:20PM
3344
April 18, 2005 06:58PM
3080
May 17, 2005 01:01PM
3473
May 22, 2005 05:59PM
2996
May 24, 2005 05:51AM
3025
May 25, 2005 12:32PM
3149
August 19, 2005 09:27AM
Re: Federated & Merge
3206
September 27, 2005 11:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.