Re: Merging Archive tables with MyISAM tables
Posted by:
Brian Aker
Date: March 01, 2006 08:48PM
Hi!
Sorry about that, now that I see what you were trying to do I will have to admit it won't work. One idea:
1) Use a trigger to back up the MYISAM table into an archive table.
2) In the SP partition the data out.
3) Always access the tables through a SP where you create dynamic SQL to pick the right table.
Cheers,
-Brian
Subject
Views
Written By
Posted
7686
November 30, 2005 10:55AM
4672
November 30, 2005 05:41PM
4214
February 01, 2006 10:02AM
4055
February 03, 2006 12:58AM
4376
March 01, 2006 04:41PM
Re: Merging Archive tables with MyISAM tables
4219
March 01, 2006 08:48PM
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.