Re: Enable deletion for archive engine.
What you would do in this instance is create one table per period of time. So if you'd want to delete the archive for one particular year (or month), you delete that one table for that year. This is easily done, as an archive table supports renaming. So you can replace your "production" table with an empty one, while renaming the current one to, say, myarchive_2009_10.
Subject
Views
Written By
Posted
9737
November 02, 2009 01:31PM
5408
November 03, 2009 02:05PM
Re: Enable deletion for archive engine.
5196
November 06, 2009 08:52AM
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.