Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Add support for REVEND_TSTMP which will enable SQL table partitioning by time

Description

There is strong desire to be able to purge old records out of a relational database by using table partitioning. In order to partition a table, you need to partition it on a column that exists within the table. So, in order to partition the _AUD tables by expired time, the timestamp of REVEND must be present within the table.

Attachments

3

Activity

Steve EbersoleMarch 21, 2011 at 7:09 PM

Bulk closing stale resolved issues

Erik-Berndt ScheperNovember 24, 2010 at 3:01 PM

Should also be fixed in 4.0.0 documenation

Erik-Berndt ScheperNovember 24, 2010 at 2:18 PM

This was already fixed in 3.6.0
Issue marked as resolved now that documentation has been added (GIT rev 2667bb4d728112a45cb37a246f8a4eaff07c644e)

AdamAOctober 5, 2010 at 9:16 PM

I agree on the additional docs - maybe you could re-use your analysis above?
Looked at the commit and it looks fine, thanks

Erik-Berndt ScheperOctober 4, 2010 at 8:21 PM

This feature should be marked as experimental.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created July 9, 2010 at 3:44 PM
Updated March 21, 2011 at 7:09 PM
Resolved November 24, 2010 at 3:02 PM