Re: Are merge tables suited for this?
It is a proven concept for log data to use a merge table. Adding a new table every so often and removing the oldest one.
Before you try this, please read about the MERGE table restrictions in the reference manual, chapters "14.2. The MERGE Storage Engine" and "14.2.1. MERGE Table Problems". If these restrictions do not affect your application, go ahead.
I do not dare to comment on performance. We have a special forum for this.
Subject
Views
Written By
Posted
5259
June 14, 2005 07:55AM
Re: Are merge tables suited for this?
3687
June 15, 2005 04:36AM
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.