On Sat, 2008-05-03 at 09:11 -0700, Christophe wrote:
I will have a log table which, once a day or so, is copied to a file
(for movement to a data warehouse), and the log table emptied.
...
Is there a better way to handle this kind of thing that I'm
missing?
Anyone care to comment about whether a table partition might be better here? Could an insert rule on a table partition automatically create the inherited table, if needed, and insert there?
Thanks,
Reece